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
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.
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
?