when a procedure /package is getting invalidated?
Answer Posted / p.rajasekar
When the referenced object's signature is changed the
procedure get invalidated or the referenced object is
changed or droped
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain two easy sql optimizations.
What does select top 1 do in sql?
What is sqlcontext?
Can I join the same table twice?
How many types of literals are available in pl sql?
How do I run a sql trace?
How does stored procedure reduce network traffic?
How do you identify a primary key?
How to make a copy values from one column to another in sql?
What is the command used to fetch first 5 characters of the string?
What is natural join in sql?
How to select 10 records from a table?
What are the advantages of pl sql over sql?
What is the use of & in pl sql?
What is pivot table in sql?