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

What is input buffer in sql*plus?

638


How does a trigger work?

533


Can you selectively load only those records that you need? : aql loader

609


discuss about myisam index statistics collection. : Sql dba

524


How do I run a query in pl sql developer?

560






What are crud methods?

551


Explain table and field in sql?

581


What is number function in sql?

525


who introduced sql?

568


When can we use the where clause and the having clause?

576


Which sql statement is used to return only different values?

501


What are tables and fields in the database?

552


How many commands are in sql?

523


Explain the difference between sql and mysql.

565


What are sql*plus environment variables?

557