User Tools

Site Tools


database:oracle:sqlplus

Switch to a pluggable db (Oracle 12)

ALTER SESSION SET container=PMJ

Connect directly to a pluggable db

sqlplus /nolog
connect SNT@PMJ

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.txt · Last modified: 2019/01/09 12:45 by odefta