If a procedure within a package is invalidated whether the
entire package will be invalid and has to be recompiled
again?
Answers were Sorted based on User's Feedback
Answer / guest
Yes, the total package body will become invalid and has to
be recompiled again
| Is This Answer Correct ? | 24 Yes | 2 No |
How many levels can subqueries be nested in a FROM clause?
Why are cursors used?
Can sql developer connect to db2?
Difference between truncate, delete and drop commands?
Define implicit and explicit cursors.
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
How much ram can sql express use?
List and explain the different types of join clauses supported in ansi-standard sql?
what is the order of pre-defined exceptions.
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
What is compound trigger?
Name the different types of indexes in sql and define them.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)