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 |
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
Explain the difference between triggers and constraints?
What is the starting oracle error number?
what is hash join
Explain table and field in sql?
What is the use of non clustered index?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING
10 Answers HCL, TCS,
How can i insert data inro a table with 3 columns using FORALL?
What is blind sql injection?
How do I remove sql developer from windows 10?
How do I partition a table 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)