关于sqlplus用法的一些总结 - 数据库编程

TOP

关于sqlplus用法的一些总结(四)

2015-07-24 10:14:55 来源: 作者: 【大中小】浏览:2次

d position.
D	99D99	Displays the decimal character to separate the integral and fractional parts of a number.
EEEE	9.999EEEE	Displays value in scientific notation (format must contain exactly four "E"s).
G	9G999	Displays the group separator in the specified positions in the integral part of a number.
L	L999	Displays the local currency symbol in the specified position.
MI	9999MI	Displays a trailing minus sign after a negative value. Display a trailing space after a positive value.
PR	9999PR	Displays a negative value in . Displays a positive value with a leading and trailing space.
RN rn	RN rn	Displays uppercase Roman numerals. Displays lowercase Roman numerals. Value can be an integer between 1 and 3999.
S	S9999 9999S	Displays a leading minus or plus sign. Displays a trailing minus or plus sign.
TM	TM	Displays the smallest number of decimal characters possible. The default is TM9. Fixed notation is used for output up to 64 characters, scientific notation for more than 64 characters. Cannot precede TM with any other element. TM can only be followed by a single 9 or E
U	U9999	Displays the dual currency symbol in the specified position.
V	999V99	Displays value multiplied by 10n, where n is the number of 9's after the V.
X	XXXX xxxx	Displays the hexadecimal value for the rounded value of the specified number of digits.

]6.设置页面，行大小

SQL> set pagesize 100
SQL> set linesize 100
SQL> select * from dba_data_files where rownum<4;
FILE_NAME
----------------------------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUT
---------- ------------------------------ ---------- ---------- --------- ------------ ---
MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_
---------- ---------- ------------ ---------- ----------- -------
/u01/app/oracle/oradata/orcl3939/user01.dbf
4 USERS 52428800 6400 AVAILABLE 4 NO
0 0 0 51380224 6272 ONLINE
/u01/app/oracle/oradata/orcl3939/undotbs01.dbf
3 UNDOTBS1 917504000 112000 AVAILABLE 3 YES
3.4360E+10 4194302 640 916455424 111872 ONLINE
/u01/app/oracle/oradata/orcl3939/sysaux01.dbf
2 SYSAUX 754974720 92160 AVAILABLE 2 YES
3.4360E+10 4194302 1280 753926144 92032 ONLINE

首页上一页 1 2 3 4 下一页尾页 4/4/4
【大中小】【打印】【繁体】【投稿】【收藏】【推荐】【举报】【评论】【关闭】【返回顶部】
分享到:
上一篇：sqlserverCAST和CONVERT函数	下一篇：SQL应用与开发：（七）数据操作&#..

帐　　号:

密码: (新用户注册)

验证码:

表　　情:

内　　容: