/* Formatted on 2005/01/25 13:05 (Formatter Plus v4.8.5) */ SET echo off REM REM SQL*Plus script to create comma delimited output file from table REM REM 20050818 Mishin A Nikolay Automate commonly done task REM SET pagesize 0 SET verify off SET feedback off SET linesize 130 -- accept owner prompt 'Enter table owner => ' ACCEPT tblname prompt 'Enter table name => ' accept clmnname prompt 'Enter need column => ' accept wherename prompt 'Enter where condition => ' SPOOL c:\Temp\csv2.sql select 'select ' || '&&clmnname' || ' from ( ' from sys.dual; select 'select ' from sys.dual; select decode(column_id,1,column_name ||' a' || column_id,','||column_name||' a' || column_id) from sys.dba_tab_columns where table_name = upper('&&tblname') order by column_id; select 'from &&tblname)' from sys.dual; select ' where &&wherename ' from sys.dual; select '/' from sys.dual; SPOOL off UNDEFINE owner UNDEFINE tblname