|
 |
| |
|
gtx
|
|
park1q
|
2018-08-22 10:59:22, 조회 : 7,360, 추천 : 1312 |
CREATE OR REPLACE VIEW OM$GTX AS
SELECT S.INDX SID,
S.KSUSESER SERIAL#,
SUBSTR(T.KXIDUSN || '.' || T.KXIDSLT || '.' || T.KXIDSQN, 1, 10) LTXID,
G.K2GTITID_ORA GTXID
FROM X$K2GTE G, X$KTCXB T, X$KSUSE S
WHERE G.K2GTDXCB = T.KTCXBXBA
AND G.K2GTDSES = T.KTCXBSES
AND S.ADDR = G.K2GTDSES
/
GRANT SELECT ON OM$GTX TO &&USERNAME; |
|
|
|
|
|
|
Technote
