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
- 7869 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 |
Temporary table vs Table variable in sql server?
What are aggregate functions in sql?
How many commands are there in sql?
Show code of a cursor for loop.
What's the difference between inner join and left join?
how to debugg a procedure or package using dbms_output.put_line in plsql
i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???
3 Answers Scope International,
Can a foreign key be a duplicate?
Explain the working of primary key?
how do you know if your mysql server is alive? : Sql dba
what are different types of keys in sql?
What is a call statement? Explain with an example.
-
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)
