DBA Data[Home] [Help] [Dependency Information]


TABLE: APPLSYS.FND_DUAL

Object Details
Object Name: FND_DUAL
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_DUAL
Subobject Name:
Status: VALID


FND_DUAL stores a dummy constant value. You always need at least
one row in this table. Oracle Application Object Library provides
this table as a base table for forms that only submit concurrent
requests (such as reporting forms) and therefore need to perform
a commit cycle without updating an application database table.
Such forms generally insert a record into this table (usually the
value 1). You should delete rows from this table occasionally, but
you should always leave at least one row in this table (for a form
that may update a record instead of inserting one).
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 5
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DUMMY NUMBER (2)
Dummy column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DUMMY
FROM APPLSYS.FND_DUAL;

Dependencies

[top of page]

APPLSYS.FND_DUAL does not reference any database object

APPLSYS.FND_DUAL is referenced by following:

SchemaAPPS
SynonymFND_DUAL