The Format Mask property specifies how to display Date and Number values in the field. You can enter custom masks for numbers and dates or you can select from the list of values. Character values have no format mask. See Date and time format mask syntax and Number format mask syntax for the correct syntax.
The values displayed initially in the list are determined by the Datatype of the field (for example, for a field of Datatype Number, only number masks are shown in the list). If you enter a mask not in the list for Format Mask and close the Field Property Inspector, the new format mask will appear in the list of values.
Applies to |
Fields |
Values |
A valid date or number mask, not to exceed 1K. |
Default |
Blank |
Required/Optional |
Optional |
PL/SQL procedure |
8
,
the value is 1234567
,
and the format mask is <NNNNNN>
,
your output will be *******
.9
)
increase the number of bytes per page taken up by your output.
Value Width of Output Source Displayed
9.99999 4 10.0
9.99999 3 10.
9.99999 2 10
9.99999 1 *
-9.99999 4 -10.
-9.99999 3 -10
-9.99999 2 **
400 2 **
4.563 5 4.563
4.563 4 4.56
4.563 3 4.6
0.001 5 .001
0.001 4 .001
0.001 3 .00
0.001 2 .0
0.001 1 .
-0.01 4 -.01
-0.01 3 -.0
-.01 2 -.
Sample Date Format Date Displayed
MM/DD/RR 03/04/85
DD MON RRRR 04 MAR 1985
Mon. DD, RRRR Mar. 4, 1985
Day Month DD fmHH:MI AM Monday March 4 11:35 AM
Dy Mon ddth fmHH24:MI:SS Mon Mar 4th 23:35:22
Day :the" ddthsp "of" Month Monday the fourth of March
Sample Number Number Number Format Displayed
-0000 7934 "7934"
-7934 "-7934"
-00000 7934 "07934"
-NNNN 7639 "7639"
535 "535"
-NNN 7639 "****"
-**** 7902 "7902"
-***** 7902 "*7902"
+NNNN 100 "+100"
-99 "-99"
(NNNN) 1600 " 1600 "
-800 "(800)"
NNNNPR 1600 " 1600 "
-800 "<800>"
NNNNMI 1600 "1600 "
-800 "800-"
NNNVNN 343 "34300"
N.NNEEEE 7369 "7.37E+03"
"SRW"-0000 7782 "SRW7782"
-$NNNN.NN 800 "$800"
1600 "$1600"
-%NNN 10 "%10"
-NN NNN.NN 3000 "3 000"
+KKNNNNN.00 1950 "+ 1950.00"
900 "+ 900.00"
$<NNNNN.00> 1200 "$ 1200.00"
500 "$ 500.00"
$<NNNNN.00> DB 1200 " 1200.00 DB"
-500 "$ 500.00"
$<NNNNN.00> CR 1200 "$ 1200.00"
-500 "$ 500.00 CR"
* The quotation marks will not appear in your output. They are used here to make it clear where there are leading or trailing spaces.
Copyright © 1984, 2005, Oracle. All rights reserved.