database:oracle:switch-to-pluggable-db-sqlplus
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
| database:oracle:switch-to-pluggable-db-sqlplus [2023/04/12 18:25] – ↷ Page name changed from database:oracle:sqlplus to database:oracle:switch-to-pluggable-db-sqlplus odefta | database:oracle:switch-to-pluggable-db-sqlplus [2023/04/12 18:26] – odefta | ||
|---|---|---|---|
| Line 30: | Line 30: | ||
| sqlplus /nolog | sqlplus /nolog | ||
| connect SNT@PMJ | 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 ' | ||
| - | |||
| - | spool C: | ||
| - | @C: | ||
| - | spool off | ||
| - | exit | ||
| - | |||
| </ | </ | ||
database/oracle/switch-to-pluggable-db-sqlplus.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1