Specifies what kinds of values Oracle Forms allows as input and how Oracle Forms displays those values.
Applies to check box, display item, list item, radio group, text item, custom item, and form parameter (form parameter supports CHAR, DATE, DATETIME, and NUMBER only)
Note: All data types do not apply to each item type.
Set Oracle Forms
The form parameter Data Type property supports the data types CHAR, DATE, and
NUMBER.
ALPHA
Contains any combination of letters (upper and/or lower case)
Default |
Null |
Example |
"Employee", "SMITH" |
CHAR
Default |
Null |
Example |
"100 Main Street", "CHAR_EXAMPLE_2" |
DATE
Default |
DD-MON-YY |
Restrictions |
Refers to a DATE column in the database and is processed as a true date, not a character string. |
The DATE data type is not intended to store a time component. |
|
Example |
01-JAN-92 |
DATETIME
Default |
DD-MON-YY HH24:MI[:SS] |
Restrictions |
Refers to a DATE column in the database and is processed as a true date, not a character string. |
The DATETIME data type contains a four digit year. If the year input to a DATETIME data type is two digits, the year is interpreted as 00YY. |
|
Example |
31-DEC-88 23:59:59 |
EDATE
Default |
DD/MM/YY |
Restrictions |
V3 data type. |
Must refer to a NUMBER column in the database. |
|
Included for backward compatibility. Instead, follow these recommendations: |
|
Use the DATE data type. |
|
Apply a format mask to produce the European date format. |
|
Reference a DATE column in the database, rather than a NUMBER column. |
|
Example |
23/10/92 (October 23, 1992) |
01/06/93 (June 1, 1993) |
INT
Default |
0 |
Example |
1, 100, -1000 |
JDATE
Default |
MM/DD/YY |
Restrictions |
V3 data type. |
Must refer to a NUMBER column in the database. |
|
Included for backward compatibility. Instead, follow these recommendations: |
|
Use the DATE data type. |
|
Apply a format mask to produce the Julian date format. |
|
Reference a DATE column in the database, rather than a NUMBER column. |
|
Example |
10/23/92 (October 23, 1992) |
06/01/93 (June 1, 1993) |
LONG
Default |
Null |
Restrictions |
Not allowed as a reference in the WHERE or ORDER BY clauses of any SELECT statement. |
LONG items are not queryable in Enter Query mode. |
MONEY
Restrictions |
V3 data type |
Included for backward compatibility. Instead, use a format mask with a number to produce the same result. |
|
Example |
10.95, 0.99, -15.47 |
NUMBER
Default |
0 |
Restrictions |
Commas cannot be entered into a number item (e.g., 99,999). Use a format mask instead. |
Example |
-1, 1, 1.01, 10.001, 1.85E3 |
Object REF
REFs
provide the ability to capture an association between two row objects.RINT
Restrictions |
V3 data type |
Included for backward compatibility. Instead, follow these recommendations: |
|
Use the NUMBER data type. |
|
Apply a format mask such as 999 to produce a right-justified number. |
RMONEY
Restrictions |
V3 data type |
Included for backward compatibility. Instead, follow these recommendations: |
|
Use the NUMBER data type |
|
Apply a format mask such as $999.99 to produce a right-justified number. |
RNUMBER
Restrictions |
V3 data type |
Included for backward compatibility. Instead, follow these recommendations: |
|
Use the NUMBER data type. |
|
Apply a format mask such as 999.999 to produce a right-justified number. |
TIME
Default |
HH24:MI[:SS] |
Restrictions |
V3 data type |
Included for backward compatibility. Instead, follow these recommendations: |
|
Use the DATETIME data type. |
|
Apply a format mask to produce only the time. |
|
Not allowed as a reference to DATE columns in the database. |
|
Example |
:10:23:05 |
21:07:13 |