create a store procedure and created synonms for that store
procedure after modify that store procedure will effect on
synonms?
If we delete the store procedure what happened to that synonms?
Answer Posted / shivaindu
If you update in store procedure it will not effort in synonyms.
If we delete the store procedure that synonyms will not
delete but it won’t work.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is dense_rank in sql?
What is the difference between view and stored procedure?
What is left join in postgresql?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Which sql statement is used to delete data from a database?
How to know the last executed procedure?
Is pl sql a scripting language?
What are the various levels of constraints?
Does postgresql run on the cloud?
What are the different operators available in sql?
What are the main features of cursor?
difference between anonymous blocks and sub-programs.
how does a local variable is defined using t-sql? : Transact sql
Why is %isopen always false for an implicit cursor?
what is primary key? : Sql dba