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


VIEW: APPLSYS.FND_DATABASES#

Object Details
Object Name: FND_DATABASES#
Object Type: VIEW
Owner: APPLSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DB_GUID RAW (16) Yes
DB_NAME VARCHAR2 (8) Yes
DB_DOMAIN VARCHAR2 (128) Yes
DEFAULT_TNS_ALIAS_GUID RAW (16)
IS_RAC_DB VARCHAR2 (1) Yes
VERSION VARCHAR2 (40) Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
SYSTEM_GUID RAW (16)
SCAN_NAME VARCHAR2 (255)
SCAN_PORT NUMBER

Query Text

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


SELECT DB_GUID
,      DB_NAME
,      DB_DOMAIN
,      DEFAULT_TNS_ALIAS_GUID
,      IS_RAC_DB
,      VERSION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SYSTEM_GUID
,      SCAN_NAME
,      SCAN_PORT
FROM APPLSYS.FND_DATABASES#;

Dependencies

[top of page]

APPLSYS.FND_DATABASES# references the following:

SchemaAPPLSYS
TableFND_DATABASES
APPLSYS.FND_DATABASES# is referenced by following:

SchemaAPPS
SynonymFND_DATABASES