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 do we need to check in database testing?
What is sql and its types?
Why is sharding used?
How will you distinguish a global variable with a local variable in pl/sql?
What is sequence in sql?
Which is faster view or stored procedure?
How can I see all tables in sql?
what is 'mysqlcheck'? : Sql dba
Is sql procedural language?
how to get @@error and @@rowcount at the same time? : Sql dba
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
How to place comments in pl/sql?
What is a sql*loader control file?
Why do we create views in sql?
What is the primary use of normalization?