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
Why join is faster than subquery?
What are sql functions? Describe in brief different types of sql functions?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
what are integrity rules?
What is a recursive join sql?
What is oracle sql developer?
Why is there a need for sqlcode and sqlerrm variables?
Is ms sql traffic encrypted?
Do we need commit after truncate?
What is a sql*loader control file?
Can a commit statement be executed as part of a trigger?
What is trigger explain it?
What is the function that is used to transfer a pl/sql table log to a database table?
Mention what is the use of function "module procedure" in pl/sql?
What is sql key?