when a procedure /package is getting invalidated?

Answer Posted / rao

When table is droped with out drop the objects
(package/procedure/function/view)

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I write a sql query in pgadmin 4?

712


what is rollback? : Sql dba

757


What is data profiling in sql?

744


What is sql keyword?

755


What is the use of pl/sql table?

758






Which sql most popular?

728


What is the non-clustered index in sql?

753


What is a loop in sql?

744


how to write date and time literals? : Sql dba

698


What are the different operators available in sql?

749


What are the types of keys?

671


What are stored procedures used for?

731


How many rows can sqlite handle?

782


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

760


Are sql connections encrypted?

747