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 |
what are the type of locks ? : Sql dba
Mention what pl/sql package consists of?
what is the difference between union and union all? : Sql dba
Is coalesce faster than isnull?
Explain autonomous transaction.
Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --
What is rownum?
what is an associative array with example?
What are the query optimization techniques?
Inline the values in PL/SQL, what does it mean.?
Which are the different types of indexes in sql?
What is the difference between left join and left outer join?
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)