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