Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 7584 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / ankush
A synonym is an alternative name for objects such as
tables, views, sequences, stored procedures, and other
database objects.
So naming convention dose not effect the object if the
object code is update or modify.
The synonym exists in the datbase but it is in a invalid
state.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is 'mysqlimport'? : Sql dba
Explain polymorphism in pl/sql.
What are sql functions? Describe in brief different types of sql functions?
what is self-join? : Sql dba
What is a unique constraint?
What is cross join example?
How do I write a sql query in pgadmin 4?
What is an exception in pl/sql?
What is sql not null constraint?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is a system versioned table?
Why primary key is required?
What is serial sql?
What is difference between inner join and cross join?
What trigger means?
