oracle格式化显示数据,oracle格式化输出

1. set long 5000：设置选对LONG或CLOB列时显示的默认字节数

2. set  linesize 1000：设置sql*plus显示的文本宽为1000字符。

3. set pagesize 9999：pagesize可以控制sql*plus多久打印一次标题，这里将pagesize设置为一个很大的数(所以每页只有一组标题)。

4. column plan_plus_exp format a80：设置由autotrace得出的解释计划输出(explain plan output)的默认宽度。A80通常足以放下整个计划

5. SQL> col A1 head 'meimei';

SQL> select * from haha;

meimei               A2

-------------------- --------------------

aa                   bb

SQL> select * from haha;

A1                   A2

-------------------- --------------------

aa                   bb

6.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]

7. SQL> help set

SET

---

Sets a system variable to alter the SQL*Plus environment settings

for your current session. For example, to:

-   set the display width for data

-   customize HTML formatting

-   enable or disable printing of column headings

-   set the number of lines per page

In iSQL*Plus, you can also use the Preferences 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}                   NUM[WIDTH] {10|n}

ARRAY[SIZE] {15|n}                       PAGES[IZE] {14|n}

AUTO[COMMIT] {OFF|ON|IMM[EDIATE]|n}      PAU[SE] {OFF|ON|text}

AUTOP[RINT] {OFF|ON}                     RECSEP {WR[APPED]|EA[CH]|OFF}

AUTORECOVERY {OFF|ON}                    RECSEPCHAR {_|c}

AUTOT[RACE] {OFF|ON|TRACE[ONLY]}         SERVEROUT[PUT] {ON|OFF}

[EXP[LAIN]] [STAT[ISTICS]]               [SIZE {n | UNLIMITED}] [FOR[MAT]

BLO[CKTERMINATOR] {.|c|ON|OFF}             {WRA[PPED] |

CMDS[EP] {;|c|OFF|ON}                       WOR[D_WRAPPED] |

COLSEP {_|text}                             TRU[NCATED]}]

CON[CAT] {.|c|ON|OFF}                   *SHIFT[INOUT] {VIS[IBLE] |

COPYC[OMMIT] {0|n}                         INV[ISIBLE]}

COPYTYPECHECK {ON|OFF}                  *SHOW[MODE] {OFF|ON}

DEF[INE] {&|c|ON|OFF}                   *SQLBL[ANKLINES] {OFF|ON}

DESCRIBE [DEPTH {1|n|ALL}]               SQLC[ASE] {MIX[ED] |

[LINENUM {OFF|ON}] [INDENT {OFF|ON}]     LO[WER] | UP[PER]}

ECHO {OFF|ON}                           *SQLCO[NTINUE] {> | text}

*EDITF[ILE] file_name[.ext]              *SQLN[UMBER] {ON|OFF}

EMB[EDDED] {OFF|ON}                      SQLPLUSCOMPAT[IBILITY] {x.y[.z]}

ESC[APE] {\|c|OFF|ON}                   *SQLPRE[FIX] {#|c}

FEED[BACK] {6|n|ON|OFF}                 *SQLP[ROMPT] {SQL>|text}

FLAGGER {OFF|ENTRY|INTERMED[IATE]|FULL}  SQLT[ERMINATOR] {;|c|ON|OFF}

*FLU[SH] {ON|OFF}                        *SUF[FIX] {SQL|text}

HEA[DING] {ON|OFF}                      *TAB {ON|OFF}

HEADS[EP] {||c|ON|OFF}                  *TERM[OUT] {ON|OFF}

INSTANCE [instance_path|LOCAL]          *TI[ME] {OFF|ON}

LIN[ESIZE] {80|n} ({150|n} iSQL*Plus)    TIMI[NG] {OFF|ON}

LOBOF[FSET] {1|n}                       *TRIM[OUT] {ON|OFF}

LOGSOURCE [pathname]                    *TRIMS[POOL] {OFF|ON}

LONG {80|n}                              UND[ERLINE] {-|c|ON|OFF}

LONGC[HUNKSIZE] {80|n}                   VER[IFY] {ON|OFF}

MARK[UP] HTML [OFF|ON]                   WRA[P] {ON|OFF}

[HEAD text] [BODY text] [TABLE text]   XQUERY {BASEURI text|

[ENTMAP {ON|OFF}]                        ORDERING{UNORDERED|

[SPOOL {OFF|ON}]                                  ORDERED|DEFAULT}|

[PRE[FORMAT] {OFF|ON}]                   NODE{BYVALUE|BYREFERENCE|

NEWP[AGE] {1|n|NONE}                            DEFAULT}|

NULL text                                  CONTEXT text}

NUMF[ORMAT] format

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