[Home] [Help] [Dependency Information]
Object Name: | PO_ADDRESS_DETAILS_GT |
---|---|
Object Type: | TABLE |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
PO.PO_ADDRESS_DETAILS_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$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCATION_ID | VARCHAR2 | (240) | ||
ADDRESS_STYLE | VARCHAR2 | (30) | ||
ADDR_LABEL_1 | VARCHAR2 | (240) | ||
ADDR_LABEL_2 | VARCHAR2 | (240) | ||
ADDR_LABEL_3 | VARCHAR2 | (240) | ||
ADDR_LABEL_4 | VARCHAR2 | (240) | ||
ADDR_LABEL_5 | VARCHAR2 | (240) | ||
ADDR_LABEL_6 | VARCHAR2 | (240) | ||
ADDR_LABEL_7 | VARCHAR2 | (240) | ||
ADDR_LABEL_8 | VARCHAR2 | (240) | ||
ADDR_LABEL_9 | VARCHAR2 | (240) | ||
ADDR_LABEL_10 | VARCHAR2 | (240) | ||
ADDR_LABEL_11 | VARCHAR2 | (240) | ||
ADDR_LABEL_12 | VARCHAR2 | (240) | ||
ADDR_LABEL_13 | VARCHAR2 | (240) | ||
ADDR_LABEL_14 | VARCHAR2 | (240) | ||
ADDR_LABEL_15 | VARCHAR2 | (240) | ||
ADDR_LABEL_16 | VARCHAR2 | (240) | ||
ADDR_LABEL_17 | VARCHAR2 | (240) | ||
ADDR_LABEL_18 | VARCHAR2 | (240) | ||
ADDR_LABEL_19 | VARCHAR2 | (240) | ||
ADDR_LABEL_20 | VARCHAR2 | (240) | ||
ADDR_DATA_1 | VARCHAR2 | (240) | ||
ADDR_DATA_2 | VARCHAR2 | (240) | ||
ADDR_DATA_3 | VARCHAR2 | (240) | ||
ADDR_DATA_4 | VARCHAR2 | (240) | ||
ADDR_DATA_5 | VARCHAR2 | (240) | ||
ADDR_DATA_6 | VARCHAR2 | (240) | ||
ADDR_DATA_7 | VARCHAR2 | (240) | ||
ADDR_DATA_8 | VARCHAR2 | (240) | ||
ADDR_DATA_9 | VARCHAR2 | (240) | ||
ADDR_DATA_10 | VARCHAR2 | (240) | ||
ADDR_DATA_11 | VARCHAR2 | (240) | ||
ADDR_DATA_12 | VARCHAR2 | (240) | ||
ADDR_DATA_13 | VARCHAR2 | (240) | ||
ADDR_DATA_14 | VARCHAR2 | (240) | ||
ADDR_DATA_15 | VARCHAR2 | (240) | ||
ADDR_DATA_16 | VARCHAR2 | (240) | ||
ADDR_DATA_17 | VARCHAR2 | (240) | ||
ADDR_DATA_18 | VARCHAR2 | (240) | ||
ADDR_DATA_19 | VARCHAR2 | (240) | ||
ADDR_DATA_20 | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT LOCATION_ID
, ADDRESS_STYLE
, ADDR_LABEL_1
, ADDR_LABEL_2
, ADDR_LABEL_3
, ADDR_LABEL_4
, ADDR_LABEL_5
, ADDR_LABEL_6
, ADDR_LABEL_7
, ADDR_LABEL_8
, ADDR_LABEL_9
, ADDR_LABEL_10
, ADDR_LABEL_11
, ADDR_LABEL_12
, ADDR_LABEL_13
, ADDR_LABEL_14
, ADDR_LABEL_15
, ADDR_LABEL_16
, ADDR_LABEL_17
, ADDR_LABEL_18
, ADDR_LABEL_19
, ADDR_LABEL_20
, ADDR_DATA_1
, ADDR_DATA_2
, ADDR_DATA_3
, ADDR_DATA_4
, ADDR_DATA_5
, ADDR_DATA_6
, ADDR_DATA_7
, ADDR_DATA_8
, ADDR_DATA_9
, ADDR_DATA_10
, ADDR_DATA_11
, ADDR_DATA_12
, ADDR_DATA_13
, ADDR_DATA_14
, ADDR_DATA_15
, ADDR_DATA_16
, ADDR_DATA_17
, ADDR_DATA_18
, ADDR_DATA_19
, ADDR_DATA_20
FROM PO.PO_ADDRESS_DETAILS_GT;
PO.PO_ADDRESS_DETAILS_GT does not reference any database object
PO.PO_ADDRESS_DETAILS_GT is referenced by following:
|
|
|