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

I have a package in which a table was used in a procedure
and compiled later i have dropped the table used in the
package what would be the status of package specification
and body

Question Posted / guntu


I have a package in which a table was used in a procedure and compiled later i have dropped the ta..

Answer / dhiraj

Package specification remain valid package body will become
invalid

Is This Answer Correct ?    21 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What are literals in sql server?

0 Answers  

what is the difference between clustered and non clustered index in sql? : Sql dba

0 Answers  

How is a process of pl/sql compiled?

0 Answers  

How can we solve sql error: ora-00904: invalid identifier?

0 Answers  

Can one improve the performance of sql*loader? : aql loader

0 Answers  




How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  

Do stored procedures prevent sql injection?

0 Answers  

What are the advantages of sql? Explain

0 Answers  

How does sql store data?

0 Answers  

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

What are the 3 modes of parameter?

0 Answers  

What is the largest value that can be stored in a byte data field?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories