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 sequences

0 Answers  

what does the t-sql command ident_incr does? : Transact sql

0 Answers  

How to revise and re-run the last sql command?

0 Answers  

What is union and union all keyword in sql?

0 Answers  

How to write pl sql program in mysql command prompt?

0 Answers  




How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

What is a primary key example?

0 Answers  

What are the advantages of stored procedure?

0 Answers  

what is heap table? : Sql dba

0 Answers  

What are the types of join and explain each?

0 Answers  

what is sp_pkeys? : Transact sql

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories