Interested to Buy Any Domain ? << Click Here >> for more details...
package specification-3 procedures
package body-4 procedures how can i write for other
procedure in package body
- 2 Answers
- 7770 Views
- Reliance, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / athilakshmi
Package Spec contains 3 procedures which is defined in the
Package Body. Those Procedures are Global.
If you want to add the 4th procedure, that to you want to
use as a local in the package, then no need to declare in
the Package Spec. directly you can declare and defined in
the package body itself.
if you want to use that 4th procedure as a global, then
you have to declare in the package specification.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / rajasekhar
The 4th procedure have to declare and implement in the body.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is audit logout in sql profiler?
Can we alter stored procedure?
How do I view an execution plan in sql?
Write the command to remove all players named sachin from the players table.
How does rowid help in running a query faster?
Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN
How to prepare for oracle pl sql certification?
Can we have exception part in trigger ?
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
How would you pass hints to the sql processor?
What steps server process has to take to execute an update statement?
Which is faster view or stored procedure?
-
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)
