SELECT
'create '
||DECODE(U.NAME,'PUBLIC','public ')
||'database link '||CHR(10)
||DECODE(U.NAME,'PUBLIC',NULL, U.NAME||'.')
|| L.NAME||CHR(10)
||'connect to ' || L.USERID || ' identified by '''
||L.PASSWORD||''' using ''' || L.host || ''''
||CHR(10)||';' TEXT
FROM
sys.LINK$ L,
sys.USER$ U
WHERE L.OWNER# = U.USER# ;
'create '
||DECODE(U.NAME,'PUBLIC','public ')
||'database link '||CHR(10)
||DECODE(U.NAME,'PUBLIC',NULL, U.NAME||'.')
|| L.NAME||CHR(10)
||'connect to ' || L.USERID || ' identified by '''
||L.PASSWORD||''' using ''' || L.host || ''''
||CHR(10)||';' TEXT
FROM
sys.LINK$ L,
sys.USER$ U
WHERE L.OWNER# = U.USER# ;
Leave a Reply