Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL PLUS Session Environment

 

Spool result to a text file

SQL> SQL> set heading off SQL> set feedback off SQL> SQL> spool c:\ALIASES.TXT SQL> SQL> select object_name || '=' || substr(object_name,1,5) from user_objects wher e object_type = 'TABLE'; MYSTATS=MYSTA WORKING_CUSTOMERS=WORKI CUST_WITH_VARRAY_TEMP_TABLE=CUST_ P1=P1 IT=IT CUST_NO_KEY_TABLE=CUST_ DEMO=DEMO P=P CUSTLOG=CUSTL IX=IX EMP_DELTAS=EMP_D PARMS=PARMS PASSWORD_AUDIT=PASSW DEPT$AUDIT=DEPT$ INVENTORY_TBL=INVEN TMP=TMP EMPLOYEETEMPTABLE=EMPLO SYSTEM_STATS=SYSTE TEMP_TABLE=TEMP_ MYTABLE1=MYTAB C1=C1 WORKING_EMPLOYEES=WORKI SQL> SQL> spool off SQL> set heading on SQL> set feedback on SQL>