Thanks for the question, Venkat.
Asked: June 29, 2016 - 12:30 pm UTC
Last updated: June 30, 2016 - 3:56 am UTC
Version: 11.2
Viewed 1000+ times
set heading on SPOOL U:\...\tt.txt ttitle left " Test report " skip 1 COLUMN A HEADING 'Last Name' format a35 column b heading 'First Name' format a35 column c heading 'Stu #' format 999999 column d heading 'Grade' format 99 select last_name A, first_name B, student_number C, grade_level D from students where schoolid = 999 and enroll_status = 0 and rownum <= 15; spool off set heading off
set heading on SPOOL c:\temp\text.txt ttitle left " Test report " skip 1 COLUMN A HEADING 'Last Name' format a35 column b heading 'First Name' format a35 column c heading 'Stu #' format 999999 column d heading 'Grade' format 99 select owner A, object_name B, object_type C from all_Objects where rownum <= 15; spool off set heading off
SQL> @c:\temp\test.sql Test report Last Name First Name Stu # ----------------------------------- ----------------------------------- ----------- SYS I_COBJ# INDEX SYS I_USER2 INDEX SYS CCOL$ TABLE SYS I_COL2 INDEX SYS FILE$ TABLE SYS C_OBJ# CLUSTER SYS C_COBJ# CLUSTER SYS I_TS1 INDEX SYS C_USER# CLUSTER SYS CLU$ TABLE SYS C_TS# CLUSTER SYS I_COL1 INDEX SYS I_OBJ5 INDEX SYS I_CDEF3 INDEX SYS I_CDEF2 INDEX 15 rows selected.
Test report Last Name First Name Stu # ----------------------------------- ----------------------------------- ----------------------- SYS I_COBJ# INDEX SYS I_USER2 INDEX SYS CCOL$ TABLE SYS I_COL2 INDEX SYS FILE$ TABLE SYS C_OBJ# CLUSTER SYS C_COBJ# CLUSTER SYS I_TS1 INDEX SYS C_USER# CLUSTER SYS CLU$ TABLE SYS C_TS# CLUSTER SYS I_COL1 INDEX SYS I_OBJ5 INDEX SYS I_CDEF3 INDEX SYS I_CDEF2 INDEX 15 rows selected.
Venkat Sagaram, June 30, 2016 - 11:41 am UTC
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!