database:oracle:sqlplus
This is an old revision of the document!
Table of Contents
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.1547030709.txt.gz ยท Last modified: 2023/07/04 19:36 (external edit)