1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



If a procedure within a package is invalidated whether the entire package will be invalid and has ..

Answer / guest

Yes, the total package body will become invalid and has to
be recompiled again

Is This Answer Correct ?    24 Yes 2 No

If a procedure within a package is invalidated whether the entire package will be invalid and has ..

Answer / rajini

It will be complained when it is referenced.

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

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

0 Answers  

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

Explain clause in sql?

0 Answers  

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,




Can we create foreign key without primary key?

0 Answers  

what is csv? : Sql dba

0 Answers  

How to handle bulk data?

0 Answers  

What is query execution plan in sql?

0 Answers  

Store procedure will return a value?

4 Answers   eMids,

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

What are tuples in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories