<- Scripts
-- sql_profile.getSQL4.sql
-- Purpose: Show SQL for given SQL profile.
-- -----------------------------------------
set linesize 1024
SET LONG 5000
SET PAGESIZE 1000
COLUMN sql_text FORMAT A100
set verify off
--DEFINE v_Profile='--Unknown--'
PROMPT SQL Profiles
PROMPT
select name from dba_sql_profiles;
PROMPT
-- Set Profile_Name
ACCEPT v_Profile PROMPT 'Profile Name: '
PROMPT
-- Get SQL
SPOOL H:\app\sql\spool\&v_Profile._sql.txt
SELECT sql_text
FROM dba_sql_profiles
WHERE name = '&v_Profile';
-- End
spool off
prompt File Created: H:\app\sql\spool\&v_Profile._sql.txt
prompt
