package specification-3 procedures
package body-4 procedures how can i write for other
procedure in package body
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 |
How do I view tables in mysql?
How do I make sql search faster?
How exception is different from error?
is mysql query is case sensitive? : Sql dba
What are different clauses used in sql?
How can I create a table from another table without copying any values from the old table?
what are date and time intervals? : Sql dba
What is duration in sql profiler trace?
What is pl sql architecture?
difference between pl/sql table and normal pl/sql table
wa procedure to return the month and the no'f developers joined in each month.
What are different types of indexes?
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)