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 |
Is it mandatory for the primary key to be given a value when a new record is inserted?
Explain the uses of database trigger.
declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?
How do I view a view in sql?
How to run sql commands in sql*plus?
How many types of relationship are there?
What is a package ? What are the advantages of packages ?
What is cursor and why it is required?
Cite the differences between execution of triggers and stored procedures?
How many types of keys are there in sql?
What is a design view?
Why do we create views in sql?
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)