-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- AUTHOR : Sameer Choudhari -- DESCRIPTION : Display the SQL Text for given SQL id -- USAGE : @display_sql_text.sql -- LAST MODIFIED : 01/10/2016 -- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SET LONG 9999999 longchunksize 9999999 pagesize 49999 linesize 220 COLUMN sql_text format a100 SELECT sql_id, sql_text FROM v$sql WHERE sql_id='&sql_id';