본문 바로가기

ORACLE/SQL

[펌]sqlplus 에서 show all & 가로 넓이를 넓게 쓰기

[ show all ]

 

show all;

정보보기

 

 

[ sqlplus에서 가로 넓이를 넓게 쓰기 ]

 

set lines[ize] 숫자

로 쓰시면 숫자에 입력한 만큼의 넓이를 사용하게 됩니다.

set lines 50

set linesize 50

이런식으로요

 

참고로

세로줄은 set pages[ize] 숫자

컬럼내용이 빈자리가 너무 클때는

col[umn] 컬럼명 format a숫자 로 하면 숫자의 크기만큼 컬럼의 내용이 보여집니다.

 

 

그 외의 setting 값들

SQL> help set

SET
---

Sets a system variable to alter the SQL*Plus environment settings
for your current session, for example:
- display width for data
- turn on HTML formatting
- enabling or disabling printing of column headings
- number of lines per page

In iSQL*Plus, you can also use the System Variables screen to set
system variables.

SET system_variable value

where system_variable and value represent one of the following clauses:

APPI[NFO]{OFF|ON|text} *NEWP[AGE] {1|n|NONE}
ARRAY[SIZE] {15|n} NULL text
AUTO[COMMIT] {OFF|ON|IMM[EDIATE]|n} NUMF[ORMAT] format
AUTOP[RINT] {OFF|ON} NUM[WIDTH] {10|n}
AUTORECOVERY {ON|OFF} PAGES[IZE] {24|n}
AUTOT[RACE] {OFF|ON|TRACE[ONLY]} *PAU[SE] {OFF|ON|text}
[EXP[LAIN]] [STAT[ISTICS]] RECSEP {WR[APPED] |
BLO[CKTERMINATOR] {.|c} EA[CH]|OFF}
CMDS[EP] {;|c|OFF|ON} RECSEPCHAR {_|c}
COLSEP {_|text} SERVEROUT[PUT] {OFF|ON}
COM[PATIBILITY] {V7|V8|NATIVE} [SIZE n] [FOR[MAT]
CON[CAT] {.|c|OFF|ON} {WRA[PPED] |
COPYC[OMMIT] {0|n} WOR[D_WRAPPED] |
COPYTYPECHECK {OFF|ON} TRU[NCATED]}]
DEF[INE] {&|c|OFF|ON} *SHIFT[INOUT] {VIS[IBLE] |
DESCRIBE [DEPTH {1|n|ALL}] INV[ISIBLE]}
[LINENUM {ON|OFF}] [INDENT {ON|OFF}] *SHOW[MODE] {OFF|ON}
ECHO {OFF|ON} *SQLBL[ANKLINES] {ON|OFF}
*EDITF[ILE] file_name[.ext] SQLC[ASE] {MIX[ED] |
EMB[EDDED] {OFF|ON} LO[WER] | UP[PER]}
ESC[APE] {|c|OFF|ON} *SQLCO[NTINUE] {> | text}
FEED[BACK] {6|n|OFF|ON} *SQLN[UMBER] {OFF|ON}
FLAGGER {OFF|ENTRY|INTERMED[IATE]|FULL} SQLPLUSCOMPAT[IBILITY] {x.y[.z]}
*FLU[SH] {OFF|ON} *SQLPRE[FIX] {#|c}
HEA[DING] {OFF|ON} *SQLP[ROMPT] {SQL>|text}
HEADS[EP] {||c|OFF|ON} SQLT[ERMINATOR]
INSTANCE [instance_path|LOCAL] {;|c|OFF|ON}
LIN[ESIZE] {80|n} ({150|n} iSQL*Plus) *SUF[FIX] {SQL|text}
LOBOF[FSET] {n|1} TAB {OFF|ON}
LOGSOURCE [pathname] TERM[OUT] {OFF|ON}
LONG {80|n} TI[ME] {OFF|ON}
LONGC[HUNKSIZE] {80|n} TIMI[NG] {OFF|ON}
MARK[UP] HTML [ON|OFF] TRIM[OUT] {OFF|ON}
[HEAD text] [BODY text] [TABLE text] TRIMS[POOL] {ON|OFF}
[ENTMAP {ON|OFF}] UND[ERLINE] {-|c|ON|OFF}
[SPOOL {ON|OFF}] VER[IFY] {OFF|ON}
[PRE[FORMAT] {ON|OFF}] WRA[P] {OFF|ON}

An asterisk (*) indicates the SET option is not supported in iSQL*Plus