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


TABLE: JTF.JTFB_TEMP_REPORT

Object Details
Object Name: JTFB_TEMP_REPORT
Object Type: TABLE
Owner: JTF
Subobject Name:
Status: VALID

Temporary Table Details

JTF.JTFB_TEMP_REPORT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
REPORT_CODE VARCHAR2 (50) Yes
ROWNO NUMBER

COL1 VARCHAR2 (128)
COL2 VARCHAR2 (128)
COL3 VARCHAR2 (128)
COL4 VARCHAR2 (128)
COL5 VARCHAR2 (128)
COL6 VARCHAR2 (128)
COL7 VARCHAR2 (128)
COL8 VARCHAR2 (128)
COL9 VARCHAR2 (128)
COL10 VARCHAR2 (128)
COL11 VARCHAR2 (128)
COL12 VARCHAR2 (128)
COL13 VARCHAR2 (128)
COL14 VARCHAR2 (128)
COL15 VARCHAR2 (128)
COL16 VARCHAR2 (128)
COL17 VARCHAR2 (128)
COL18 VARCHAR2 (128)
COL19 VARCHAR2 (128)
COL20 VARCHAR2 (128)
COL21 VARCHAR2 (128)
COL22 VARCHAR2 (128)
COL23 VARCHAR2 (128)
COL24 VARCHAR2 (128)
COL25 VARCHAR2 (128)
COL26 VARCHAR2 (128)
COL27 VARCHAR2 (128)
COL28 VARCHAR2 (128)
COL29 VARCHAR2 (128)
COL30 VARCHAR2 (128)
COL31 VARCHAR2 (128)
COL32 VARCHAR2 (128)
COL33 VARCHAR2 (128)
COL34 VARCHAR2 (128)
COL35 VARCHAR2 (128)
COL36 VARCHAR2 (128)
COL37 VARCHAR2 (128)
COL38 VARCHAR2 (128)
COL39 VARCHAR2 (128)
COL40 VARCHAR2 (128)
Query Text

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


SELECT REPORT_CODE
,      ROWNO
,      COL1
,      COL2
,      COL3
,      COL4
,      COL5
,      COL6
,      COL7
,      COL8
,      COL9
,      COL10
,      COL11
,      COL12
,      COL13
,      COL14
,      COL15
,      COL16
,      COL17
,      COL18
,      COL19
,      COL20
,      COL21
,      COL22
,      COL23
,      COL24
,      COL25
,      COL26
,      COL27
,      COL28
,      COL29
,      COL30
,      COL31
,      COL32
,      COL33
,      COL34
,      COL35
,      COL36
,      COL37
,      COL38
,      COL39
,      COL40
FROM JTF.JTFB_TEMP_REPORT;

Dependencies

[top of page]

JTF.JTFB_TEMP_REPORT does not reference any database object

JTF.JTFB_TEMP_REPORT is referenced by following:

SchemaAPPS
SynonymJTFB_TEMP_REPORT