Saturday, March 8, 2014

What is Synonym in oracle?


SYNONYM:-
            Synonym is the another or alternate name of the database object.
            We can create synonym of TABLE, VIEW, SEQUENCE, INDEX, PROCEDURE, FUNCTION, TRIGGER, PACKAGE etc.
           
Syntax:-

    CREATE [PUBLIC] S
    SYNONYM synonym_name
    FOR object_name;
   
Example:-

    CREATE SYNONYM XXC05_SEQ_SYN
    FOR XXC05_SEQ;   
   
Note:- XXC05_SEQ is the name of sequence.

Drop Synonym:-

    DROP SYNONYM synonym_name;

Example:-

    DROP SYNONYM XXC05_SEQ_SYN;




No comments:

Post a Comment