I have a package in which a table was used in a procedure and compiled later i

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

1 Answers
6467 Views
TCS, I also Faced
E-Mail Answers

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

Is mariadb a nosql database?

0 Answers

What is the difference between python and sql?

0 Answers

What are sql ddl commands?

0 Answers

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers

How to display all Friday's in a year with date?

4 Answers Flipkart,

explain primary keys and auto increment fields in mysql : sql dba

0 Answers

What is the difference between mdf and ndf files?

0 Answers

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers

What is a constraint? Tell me about its various levels.

0 Answers

What are all the different types of indexes?

0 Answers

What are the types of operators available in sql?

0 Answers

What is mutating trigger?

0 Answers

For more SQL PLSQL Interview Questions Click Here