Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4816 Views
- I also Faced
- E-Mail Answers
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 is view? Can we update view
Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?
How do you create an update query?
what is union, minus and interact commands? : Sql dba
Is like operator in sql case sensitive?
What is the difference between delete, truncate and drop command?
How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?
What are dml commands?
What is difference between inner join and cross join?
what is the difference between primary key and unique key? : Sql dba
Write the command to remove all players named sachin from the players table.
How is use pl and sql?
-
Oracle (3253) - 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)
