[Home] [Help] [Dependency Information]
Object Name: | GR_TOXIC_CALC_TBL |
---|---|
Object Type: | TABLE |
Owner: | GR |
Subobject Name: | |
Status: | VALID |
GR.GR_TOXIC_CALC_TBL 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 |
---|---|---|---|---|
PRODUCT_CODE | VARCHAR2 | (32) | ||
INGREDIENT_CODE | VARCHAR2 | (32) | ||
LABEL_CODE | VARCHAR2 | (5) | ||
TOXIC_EXPOSURE_CODE | VARCHAR2 | (4) | ||
TOXIC_ROUTE_CODE | VARCHAR2 | (3) | ||
TOXIC_SPECIES_DESC | VARCHAR2 | (240) | ||
TOXIC_DOSE | NUMBER | (15) | ||
CONC_PCT | NUMBER | |||
WGT_PCT | NUMBER | |||
TOXIC_UOM | VARCHAR2 | (1) | ||
PRODUCT_VALUE | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PRODUCT_CODE
, INGREDIENT_CODE
, LABEL_CODE
, TOXIC_EXPOSURE_CODE
, TOXIC_ROUTE_CODE
, TOXIC_SPECIES_DESC
, TOXIC_DOSE
, CONC_PCT
, WGT_PCT
, TOXIC_UOM
, PRODUCT_VALUE
FROM GR.GR_TOXIC_CALC_TBL;
GR.GR_TOXIC_CALC_TBL does not reference any database object
GR.GR_TOXIC_CALC_TBL is referenced by following:
|
|
|