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.

Answer / rajasekhar

The 4th procedure have to declare and implement in the body.

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?

12 Answers   Oracle,

---

What language is oracle sql developer?

0 Answers  

---

Explain foreign key in sql?

0 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

0 Answers  

---

---

What is the maximum number of triggers,can apply to a single table?

2 Answers  

---

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

---

what are date and time data types? : Sql dba

0 Answers  

---

What is pl sql code?

0 Answers  

---

What are all the ddl commands?

0 Answers  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers  

---