eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PO.PO_SESSION_GT

Object Details

Object Name:	PO_SESSION_GT
Object Type:	TABLE
Owner:	PO
Subobject Name:
Status:	VALID

For Internal Use Only

Temporary Table Details

PO.PO_SESSION_GT 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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Column
PO_SESSION_GT_N1	NORMAL	NONUNIQUE	KEY
PO_SESSION_GT_N2	NORMAL	NONUNIQUE	INDEX_NUM1
PO_SESSION_GT_N3	NORMAL	NONUNIQUE	INDEX_NUM2
PO_SESSION_GT_N4	NORMAL	NONUNIQUE	INDEX_CHAR1
PO_SESSION_GT_N5	NORMAL	NONUNIQUE	INDEX_CHAR2

Columns

Name	Datatype	Length
KEY	NUMBER
NUM1	NUMBER
NUM2	NUMBER
NUM3	NUMBER
NUM4	NUMBER
NUM5	NUMBER
NUM6	NUMBER
NUM7	NUMBER
NUM8	NUMBER
NUM9	NUMBER
NUM10	NUMBER
CHAR1	VARCHAR2	(4000)
CHAR2	VARCHAR2	(4000)
CHAR3	VARCHAR2	(4000)
CHAR4	VARCHAR2	(4000)
CHAR5	VARCHAR2	(4000)
DATE1	DATE
DATE2	DATE
INDEX_NUM1	NUMBER
INDEX_NUM2	NUMBER
INDEX_CHAR1	VARCHAR2	(100)
INDEX_CHAR2	VARCHAR2	(100)
CHAR6	VARCHAR2	(4000)

Query Text

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


SELECT KEY
,      NUM1
,      NUM2
,      NUM3
,      NUM4
,      NUM5
,      NUM6
,      NUM7
,      NUM8
,      NUM9
,      NUM10
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      DATE1
,      DATE2
,      INDEX_NUM1
,      INDEX_NUM2
,      INDEX_CHAR1
,      INDEX_CHAR2
,      CHAR6
FROM PO.PO_SESSION_GT;

Dependencies

[top of page]

PO.PO_SESSION_GT does not reference any database object

PO.PO_SESSION_GT is referenced by following:

APPS: PO_SESSION_GT