Sign Up Login


  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 clustered and non-clustered indexes?

0 Answers  

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

What has stored procedures in sql?

0 Answers  

Can we perform dml in function?

0 Answers  

Is left join inner or outer?

0 Answers  




what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

What operating systems are supported by oracle sql developer?

0 Answers  

Is left join same as inner join?

0 Answers  

What is delimiter in pl sql?

0 Answers  

What is acid property in a database?

0 Answers  

Why use subqueries instead of joins?

0 Answers  

What are the basic techniques of indexing?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories