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


TABLE: JTF.JTFB_TEMP_BIN

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

Temporary Table Details

JTF.JTFB_TEMP_BIN 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
BIN_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)
Query Text

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


SELECT BIN_CODE
,      ROWNO
,      COL1
,      COL2
,      COL3
,      COL4
,      COL5
,      COL6
,      COL7
,      COL8
,      COL9
,      COL10
,      COL11
,      COL12
,      COL13
,      COL14
,      COL15
,      COL16
FROM JTF.JTFB_TEMP_BIN;

Dependencies

[top of page]

JTF.JTFB_TEMP_BIN does not reference any database object

JTF.JTFB_TEMP_BIN is referenced by following:

SchemaAPPS
SynonymJTFB_TEMP_BIN