If a procedure within a package is invalidated whether the
entire package will be invalid and has to be recompiled
again?

Answer Posted / rajini

It will be complained when it is referenced.

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you update sql?

707


What is a left join?

690


How do you pronounce sql?

725


what is the difference between a having clause and a where clause? : Sql dba

690


What is a native sql query?

699






what is a field in a database ? : Sql dba

754


Define SQL and state the differences between SQL and other conventional programming Languages?

870


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3577


How can we link a sql database to an existing android app?

728


Is trigger a stored procedure?

698


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

743


How is sql used in oracle?

755


Explain normalization and what are the advantages of it?

690


What operators deal with null?

811


What is the purpose of using pl/sql?

825