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
- 7779 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 number function in sql?
How do I truncate a sql log file?
Is pl sql different from sql?
What is a native sql query?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is the difference between count 1 and count (*) in a sql query?
Delete duplicate records in the emp table.
How do I view a procedure in sql?
How many types of privileges are available in sql?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
What are the two types of exceptions.
-
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)
