--匯出所有的同義詞
SELECT 'CREATE OR REPLACE PUBLIC SYNONYM ' || '"' || SYNONYM_NAME || '"' ||
' FOR ' || '"' || TABLE_OWNER || '"' || '.' || '"' || TABLE_NAME || '"' || ';'
FROM DBA_SYNONYMS A
WHERE A.TABLE_OWNER IN ('ACCT','BLDBANK','COMM','CPR','ECONSTAT','EQUIPMENT','EXAM','INFECT','INPADM','INPBILL','INQUIRE','INSURANCE','LAB',
'MEDADM','MEDREC','NURSING','ORDADM','OUTPADM','OUTPBILL','OUTPDOCT','PHARMACY','PHYEXAM','SURGERY','TJRIS') ;

匯出Oracle中的同義詞

相關文章