12 lines
463 B
MySQL
12 lines
463 B
MySQL
|
|
--------------------------------------------------------
|
||
|
|
-- DDL for Table TMP_REFERENCE_LIST_ADD
|
||
|
|
--------------------------------------------------------
|
||
|
|
|
||
|
|
CREATE GLOBAL TEMPORARY TABLE "ENVX_OPER"."TMP_REFERENCE_LIST_ADD"
|
||
|
|
( "ID_REFERENCE" VARCHAR2(100 BYTE),
|
||
|
|
"ID_REQUEST" NUMBER,
|
||
|
|
"ID_REF_SOURCE" NUMBER,
|
||
|
|
"REFERENCE_DESCRIPTION" VARCHAR2(500 BYTE)
|
||
|
|
) ON COMMIT PRESERVE ROWS ;
|
||
|
|
GRANT SELECT ON "ENVX_OPER"."TMP_REFERENCE_LIST_ADD" TO "ENVX_AUDIT";
|