want to run synonym script where schema should be passed parameter as once
875568Jul 28 2011 — edited Jul 28 2011HI,
I Want to run creation of synonym script where schema should be entered only once.
My synonym script is as follows.I Should enter user or schema only once for all the synonyms.
CREATE SYNONYM EMP FOR & user .EMP ;
CREATE SYNONYM DEPT FOR & user .DEPT ;
CREATE SYNONYM EMPDEPT FOR & user .EMPDEPT ;
and so on
pls anyone help ne out
thanks