Uzitocne v napr. skriptoch<\/p>\n
COLUMN
\nSpecifies display attributes for a given column, such as, column heading text, column heading alignment, data format, column data wrapping.
\nAlso lists the current display attributes for a single column or all columns.<\/p>\n
Syntax: \tCOLUMN [ {column_name | expr} ] option
\nCOL \tLists current display attributes for all column_name currently defined.
\nCOL column_name \tLists current display attributes for column_name.
\nCOL expr \tLists current display attributes for expr.<\/p>\n
ALIAS alias
\n\tAssign an alias to a column_name, which can be used by BREAK, COMPUTE, and other COLUMN commands. Example: COL em_salary+em_bonus ALIAS tot_income
\nCLEAR
\n\tResets the display attributes for the column_name to default values. To reset the attributes for all column_name s, use the CLEAR COLUMNS command. CLEAR COLUMNS also clears the display attributes for that column_name.
\nFOLD_AFTER
\n\tInserts a carriage return after the column heading and after each row in the column. SQLPlus does not insert an extra carriage return after the last column in the SELECT list.
\nFOLD_BEFORE
\n\tInserts a carriage return before the column heading and before each row of the column. SQLPlus does not insert an extra carriage return before the first column in the SELECT list.
\nFORMAT format_model
\n\tSpecifies the display format_model of the column. The format_model specification must be a text constant such as A10 or $9,999–not a variable. Example: COL emp_name FOR A15
\nHEADING text
\n\tDefines a column heading to text. If HEADING is not used, the column’s heading defaults to column_name or expr. If text contains blanks or punctuation characters, it must be enclosed with single or double quotes. Each occurrence of the HEADSEP character (by default, | (pipe) ) begins a new line. Example: COL last_name HEADING ‘Employee | Name’ produces a two-line column heading.
\nJUSTIFY {LEFT | CENTER | RIGHT}
\n\tAligns the heading, not data. Without the JUSTIFY clause, headings for NUMBER columns default to RIGHT and headings for other column types default to LEFT.
\nLIKE {expr | alias}
\n\tCopies the display attributes of another column_name or expr (whose attributes which have already been defined with another COLUMN command). LIKE copies only attributes not defined by another clause in the current COLUMN command.
\nNEWLINE
\n\tStarts a new line before displaying the column’s value. NEWLINE has the same effect as FOLD_BEFORE.
\nNEW_VALUE variable
\n\tSpecifies a variable to hold a column_name value. This variable can be referenced in the variable in TITLE commands. Use NEW_VALUE to display column values or the date in the top title.
\nNOPRINT | PRINT
\n\tControls the printing of the column (the column heading and all the selected values). NOPRINT turns off the screen output and printing of the column. PRINT turns the printing of the column on.
\nNULL text
\n\tReplace a null value with ‘text’. The NULL clause of the COLUMN command overrides the SET NULL clause for a given column.
\nOLD_VALUE variable
\n\tSpecify a variable to hold a column value. (see BTITLE)
\nON | OFF
\n\tControls the status of display attributes for a column. OFF disables the attributes for a column without affecting the attributes’ definition. ON reinstates the attributes.
\nWRAPPED | WORD_WRAPPED | TRUNCATED
\n\tSpecifies how to treat long CHAR strings. WRAPPED wraps string within the column bounds, begins new lines when required. WORD_WRAP is enabled, SQLPlus left justifies each new line, skipping all leading whitespace (for example, returns, newline characters, tabs and spaces), including embedded newline characters.<\/p>\n","protected":false},"excerpt":{"rendered":"
Uzitocne v napr. skriptoch COLUMN Specifies display attributes for a given column, such as, column heading text, column heading alignment, data format, column data wrapping. Also lists the current display attributes for a single column or all columns. Syntax: COLUMN [ {column_name | expr} ] option COL Lists current display attributes for all column_name currently […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-177","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=177"}],"version-history":[{"count":5,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/177\/revisions"}],"predecessor-version":[{"id":182,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/177\/revisions\/182"}],"wp:attachment":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}