A script-enabled browser is required for this page to function properly.

Data Type Property

Description

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

Usage Notes

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

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



Format Mask property