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 |
how to install mysql? : Sql dba
what is index? : Sql dba
Explain scalar functions in sql?
What does trigger mean in slang?
What is a .db file?
What does seeding a database mean?
How to return an array from java to pl/sql?
how do you login to mysql using unix shell? : Sql dba
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?
Explain mutating table error.
SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows
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)