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
How do you use collections in procedure to return the resultset?
What sql does db2 use?
What is multiple partition?
What is the difference between numeric and autonumber?
Is pl sql useful?
What is an inconsistent dependency?
Can a foreign key be null?
Is primary key clustered index?
Can we insert in view in sql?
What operating systems are supported by oracle sql developer?
What does bitemporal mean?
How do I run a sql script?
How to run sql*plus commands in sql developer?
What is cascade in sql?
how to use case expression? : Sql dba