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

What is offset and limit in sql?

0 Answers

Can you have multiple SPs with the same name on a database?

6 Answers CGI,

What is sql indexing?

0 Answers

what is log shipping? : Sql dba

0 Answers

What is view explain with example?

0 Answers

What is pl sql script?

0 Answers

what are the security recommendations while using mysql? : Sql dba

0 Answers

Explain the components of sql?

0 Answers

What is varchar data type in sql?

0 Answers

What is trigger in sql and its types?

0 Answers

Write one update command to update seqno field of a table on the basis of row number.

4 Answers HCL,

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers

For more SQL PLSQL Interview Questions Click Here