Payal Shah

• Sep 5th, 2011

 

Synonum is a alias of the table..

jimmy.katiyar11

 Profile Answers by jimmy.katiyar11 

• Nov 29th, 2011

 

Hi,

In oracle use SYNONYM as a temporary name of the object ( Table, view, index etc.)

Code
 


  CREATE SYNONYM synonym_name FOR table_name


 


You CREATE PUBLIC SYNONYM WITH the PUBLIC keywrd


 


 


CREATE PUBLIC SYNONYM synonym_name FOR table_name