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 is bdb (berkeleydb)? : Sql dba

0 Answers  

How to read xml file in oracle pl sql?

0 Answers  

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

What found sql?

0 Answers  

What is clause?

0 Answers  




What is the difference between microsoft sql and mysql?

0 Answers  

What is the difference between nvl function, ifnull function, and isnull function?

0 Answers  

What are the advantages of pl sql over sql?

0 Answers  

what are the type of locks ? : Sql dba

0 Answers  

Can we join same table in sql?

0 Answers  

What is sql scripting?

0 Answers  

Why use subqueries instead of joins?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories