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 |
What are different types of queries in sql?
What is the difference between rename and alias?
Explain what is a database?
explain what is mysql? : Sql dba
what is msql? : Sql dba
i want to display 1 to 10 numbers using one select statement.
18 Answers HCL, Nyros, Oracle,
write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.
What can be a size of a pl/sql block? Is there any limit?
What is left join in postgresql?
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
Can procedure in package be overloaded?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
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)