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 ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What kind of join is join?

704


What problem one might face while writing log information to a data-base table in pl/sql?

761


Explain the advantages and disadvantages of stored procedure?

853


Define tables and fields in a database

834


How many triggers can be applied on a table?

672






What is the difference between count 1 and count (*) in a sql query?

667


What is offset and limit in sql?

744


What is a trigger in sql?

887


What is sqlerrd?

699


is it possible to pass an object or table to a procedure as an argument?

818


How do I create a sql script?

761


what is 'mysqldump'? : Sql dba

761


What is the difference among union, minus and intersect?

731


What is mdb stand for?

733


What is nosql db?

712