- set heading on|off
SQL> set heading off SQL> select * from dba_directories; SYS TEST_DIR /RealData/oracle/backup/data_pump SYS SUBDIR /RealData/oracle/demo/schema/order_entry//2002/Sep SYS SS_OE_XMLDIR /RealData/oracle/demo/schema/order_entry/ SYS LOG_FILE_DIR /RealData/oracle/demo/schema/log/ SYS DATA_FILE_DIR /RealData/oracle/demo/schema/sales_history/ SYS XMLDIR /ade/b/2125410156/oracle/rdbms/xml SYS MEDIA_DIR /RealData/oracle/demo/schema/product_media/ SYS DATA_PUMP_DIR /RealData/admin/DATACENTER/dpdump/ SYS ORACLE_OCM_CONFIG_DIR /RealData/oracle/ccr/state 9 rows selected. SQL> set heading on SQL> select * from dba_directories; OWNER DIRECTORY_NAME DIRECTORY_PATH ------------------------------ ------------------------------ -------------------------------------------------- SYS TEST_DIR /RealData/oracle/backup/data_pump SYS SUBDIR /RealData/oracle/demo/schema/order_entry//2002/Sep SYS SS_OE_XMLDIR /RealData/oracle/demo/schema/order_entry/ SYS LOG_FILE_DIR /RealData/oracle/demo/schema/log/ SYS DATA_FILE_DIR /RealData/oracle/demo/schema/sales_history/ SYS XMLDIR /ade/b/2125410156/oracle/rdbms/xml SYS MEDIA_DIR /RealData/oracle/demo/schema/product_media/ SYS DATA_PUMP_DIR /RealData/admin/DATACENTER/dpdump/ SYS ORACLE_OCM_CONFIG_DIR /RealData/oracle/ccr/state 9 rows selected.