If you have to declare procedure1,procedure2 in package
specification and if you have to declare
procedure1,procedure2 and procedure3 in package body? is it
compilation or not and execute or not? what type of error
is given please
Answer / rajesh venati
No, error will occur, because you declared procedure1 and
procedure2 in specification, those are must and should be
define in the package body, other wise it raise an error.
We can declare any no of procedures in body, with out
declared in specification, those are accessible only local.
| Is This Answer Correct ? | 10 Yes | 0 No |
what are the types of subquery? : Sql dba
what is clause? : Sql dba
how many triggers are allowed in mysql table? : Sql dba
Why do we use view in sql?
Can you join views in sql?
How does cross join work?
Show how functions and procedures are called in a pl/sql block.
If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please
Is subquery faster than join?
What is dbo in sql?
What is the difference between the implicit and explicit cursors?
What are the types of functions 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)