-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Author       : Sameer S Choudhari
-- Description  : List the SQL Text for give SQL_ID
-- Call Syntax  : @list_sql_text.sql
-- Last Modified: 17/03/2015
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COLUMN sql_text FORMAT a100
SELECT sql_id,
       sql_text
FROM v$sql WHERE sql_id='&sql_id';