How to derive synonyms in Oracle

This article focuses on "how to derive synonyms in Oracle". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to export synonyms in Oracle.

-- export all synonyms

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')

At this point, I believe you have a deeper understanding of "how to derive synonyms in Oracle". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!