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

In pl/sql, what is bulk binding, and when/how would it help performance?

521


When to use inner join and left join?

516


What is the difference between nested table and varray?

510


what is 'trigger' in sql? : Sql dba

547


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

676






How many triggers can be applied on a table?

497


When should I use nosql database?

544


What does pl sql stand for?

649


What is %type in sql?

506


What is a .db file?

529


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1550


How are sql commands classified?

583


What is fmtonly in sql?

522


Can we write ddl statements in functions?

559


What are schema-level triggers?

570