Dec 4, 2009

select view and function throufh db link

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'

0 意見: