how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

a query to select maxmun 3 salaries of employee table

12 Answers   IBM, Polaris,

---

What is the difference between a vector and an Array? (Java)

3 Answers   RBS,

---

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

2 Answers   Wipro,

---

How to bring a tablespace online?

0 Answers  

---

---

What is the difference between online and offline backups?

0 Answers   MCN Solutions,

---

How to export several tables together?

0 Answers  

---

What is currency type in database ?

3 Answers   TCS,

---

Write query to fetch second maximum salary from employee table.

4 Answers   Bravura Solutions, HCL,

---

Can anyone give me information about oracle certification

1 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

List out the difference between commit, rollback, and savepoint?

0 Answers  

---