User Tools

Site Tools


database:oracle:sqlplus-format-output

Format sqlplus output

set linesize 2500
set wrap off
set trimout on
set trimspool on
set long 100000
set pagesize 0
col inmemory_service_name for a10
col table_name for a10
col cluster_name for a20
col cluster_owner for a20
col iot_name for a10
col default_collation for a10
COLUMN first_name FORMAT A10 WORD_WRAP HEADING 'Name' JUSTIFY CENTER

spool C:\buffer\out.txt
@C:\buffer\sql.txt
spool off
exit
database/oracle/sqlplus-format-output.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1