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


VIEW: APPLSYS.FND_LOBS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
FILE_ID NUMBER
Yes
FILE_NAME VARCHAR2 (256)
FILE_CONTENT_TYPE VARCHAR2 (256) Yes
FILE_DATA BLOB (4000)
UPLOAD_DATE DATE

EXPIRATION_DATE DATE

PROGRAM_NAME VARCHAR2 (32)
PROGRAM_TAG VARCHAR2 (32)
LANGUAGE VARCHAR2 (4)
ORACLE_CHARSET VARCHAR2 (30)
FILE_FORMAT VARCHAR2 (10) Yes
Query Text

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


SELECT FILE_ID
,      FILE_NAME
,      FILE_CONTENT_TYPE
,      FILE_DATA
,      UPLOAD_DATE
,      EXPIRATION_DATE
,      PROGRAM_NAME
,      PROGRAM_TAG
,      LANGUAGE
,      ORACLE_CHARSET
,      FILE_FORMAT
FROM APPLSYS.FND_LOBS#;

Dependencies

[top of page]

APPLSYS.FND_LOBS# references the following:

SchemaAPPLSYS
TableFND_LOBS
APPLSYS.FND_LOBS# is referenced by following:

SchemaAPPS
SynonymFND_LOBS