Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 BY ANY OTHER NAME If you do not wish to qualify an object name for which youve been granted access you can create a synonym A synonym is an alias for a qualified object name Listing 4 shows the SQL statement you use to create a synonym The syntax at its simplest is CREATE OR REPLACE SYNONYM synonym name FOR qualified object name Code Listing 4 Create a synonym to use as an alias for a qualified object name SQL connect as sysdba Connected ORACLE MAGAZINE JANUARY FEBRUARY 2018 121 SQL alter session set container bynd Session altered SQL grant create synonym to beyond_ 101 Grant succeeded SQL connect beyond_ 101@ bynd Enter password Connected SQL CREATE SYNONYM employee FOR sql_ 201 employee Synonym created
You must have JavaScript enabled to view digital editions.