col username format a4
a表示字符型，4为1行显示4个字符。
SQL
>
col
COLUMN
interacted
ON
FORMAT a30
COLUMN
result_plus_xquery
ON
HEADING
'
Result Sequence
'
COLUMN
other_plus_exp
ON
FORMAT a44
COLUMN
other_tag_plus_exp
ON
FORMAT a29
COLUMN
object_node_plus_exp
ON
FORMAT a8
COLUMN
plan_plus_exp
ON
FORMAT a60
COLUMN
parent_id_plus_exp
ON
HEADING
'
p
'
FORMAT
990
COLUMN
id_plus_exp
ON
HEADING
'
i
'
FORMAT
990
COLUMN
droptime_plus_show_recyc
ON
HEADING
'
DROP TIME
'
FORMAT a19
COLUMN
objtype_plus_show_recyc
ON
HEADING
'
OBJECT TYPE
'
FORMAT a12
COLUMN
objectname_plus_show_recyc
ON
HEADING
'
RECYCLEBIN NAME
'
FORMAT a30
COLUMN
origname_plus_show_recyc
ON
HEADING
'
ORIGINAL NAME
'
FORMAT a16
COLUMN
value_col_plus_show_param
ON
HEADING
'
VALUE
'
FORMAT a30
COLUMN
name_col_plus_show_param
ON
HEADING
'
NAME
'
FORMAT a36
COLUMN
units_col_plus_show_sga
ON
FORMAT a15
COLUMN
name_col_plus_show_sga
ON
FORMAT a24
COLUMN
ERROR
ON
FORMAT A65word_wrap
COLUMN
LINE
/
COL
ON
FORMAT A8
COLUMN
ROWLABEL
ON
FORMAT A15
SQL
>
help col
COLUMN
--
----
Specifies display attributes
for
a given
column
, such
as
:
-
text
for
the
column
heading
-
alignment
for
the
column
heading
-
format
for
NUMBER
data
-
wrapping
of
column
data Also lists the
current
display attributes
for
a
single
column
or
all
columns. COL
[
UMN
]
[
{column | expr} [option ...
]
]
where
option
represents one
of
the following clauses: ALI
[
AS
]
alias CLE
[
AR
]
ENTMAP {
ON
|
OFF
} FOLD_A
[
FTER
]
FOLD_B
[
EFORE
]
FOR
[
MAT
]
format HEA
[
DING
]
text
JUS
[
TIFY
]
{L
[
EFT
]
|
C
[
ENTER
]
|
R
[
IGHT
]
}
LIKE
{expr
|
alias} NEWL
[
INE
]
NEW_V
[
ALUE
]
variable NOPRI
[
NT
]
|
PRI
[
NT
]
NUL
[
L
]
text
OLD_V
[
ALUE
]
variable
ON
|
OFF
WRA
[
PPED
]
|
WOR
[
D_WRAPPED
]
|
TRU
[
NCATED
]
扫一扫
2929
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
