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 are different types of refreshment techniques of materialised view
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Why primary key is required?
How will you distinguish a global variable with a local variable in pl/sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What are the different types of functions in sql?
define data blocks ? : Sql dba
What is the Difference between Procedure and Function.Can we call a Function in a DML?
<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?
What is #table in sql?
How to assign sql query results to pl sql variables?
What are all the ddl commands?
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)