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
6472 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

Can dml statements be used in pl/sql?

0 Answers

what are the differences between binary and varbinary? : Sql dba

0 Answers

How you will create Toad Function?

1 Answers

What are the different tcl commands in sql?

0 Answers

What is schema in sql example?

0 Answers

Is it possible for a table to have more than one foreign key?

0 Answers

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers

while loading data into database how can u skip header and footer records in sql*loader

1 Answers Oracle,

Can you create a table with Primary Key not as the clustered index.

2 Answers CGI,

What are transaction and its controls?

0 Answers

What is left join in sql?

0 Answers

What does 0 mean in sql?

0 Answers

For more SQL PLSQL Interview Questions Click Here