select view and function throufh db link.
get_entryvalue is a function in remote DB.
-----------
SELECT ip3.ID,
ip3.CLASS,
ip3.subclass,
ip3.item_number,
ip3.description,
ip3.list32,
ip3.list33,
A.get_entryvalue@A_DB_LINK (ip3.list32) type,
A.get_entryvalue@A_DB_LINK (ip3.list33) group
FROM A.item_p3@A_DB_LINK ip3
WHERE subclass = '123456'
Dec 4, 2009
select view and function throufh db link
Subscribe to:
Post Comments (Atom)
0 意見:
Post a Comment