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
Answer Posted / dhiraj
Package specification remain valid package body will become
invalid
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
Can we use distinct and group by together?
How to prepare for oracle pl sql certification?
What is a left join?
Can we use threading in pl/sql?
How do you declare a variable in pl sql?
Are stored procedures faster than queries?
What is sorting in sql?
Can we use having without group by in sql?
Is it possible to create startup or shutdown trigger for on-schema?
What are the parts of a basic sql query?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is mutating error in pl sql?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is mutating sql table?
What are the advantages of indexing?