Oracle Sqlplus formatted output

1-show pagesize # # #显示页行数

Set PageSize # # #显示页行数为300

2-show Linesize # # #显示行宽度

Set Linesize # # #显示行宽度为300

3-show Numwidth # # #显示数字字段长度

Set Numwidth Ten # # #显示数字列长度

4-Save Forever

/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/glogin.sql # # #此为linux路径

# # #window还需要设置dos窗口的大小

Set pagesize 300

Set Linesize 300

Set Numwidth 10

5-Column format settings

Col colname for A20 # # # #设置字符串, or a Time Type column field width of 20, cannot be set as a numeric type, otherwise the display is "#######"

Col colname for $99999/99999999 # # # #显示数字类型的列或钱数

Oracle Sqlplus formatted output