package specification-3 procedures
package body-2 procedures will is execute
Answers were Sorted based on User's Feedback
Answer / umesh joshi
Package specification can be compiled without compiling
package body, whereas package body cannot be compile
without specification compilation
| Is This Answer Correct ? | 21 Yes | 0 No |
Answer / ajexpert
No.
Package body should contain the same number and type of
objects as declared in package specification
| Is This Answer Correct ? | 11 Yes | 11 No |
What is a column in a table?
Define a temp table?
3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);
What does select top 1 do in sql?
i have some prob lem to tell me about my self in interview first round ...
What will you get by the cursor attribute sql%notfound?
what are Dynamic SQL statements?
What are the parts of a sql statement?
What is sql not null constraint?
what are properties of a transaction? : Sql dba
How can a function retun more than one value in oracle with proper example?
Does view contain data?
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)