-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 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';