How to assign a table row to a record variable?

0 Answers  

---

How many memory layers are in the oracle shared pool?

0 Answers  

---

find the second highest salary of the emp table

6 Answers  

---

What is self-referential integrity constraint ?

2 Answers   SunGard,

---

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  

---

How do I connect to oracle database?

0 Answers  

---

How to start a new transaction in oracle?

0 Answers  

---

What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,

---

Differentiate between TRUNCATE and DELETE?

2 Answers  

---

How you open and close a cursor variable.Why it is required?

2 Answers  

---

what is the difference between UNION AND UNIONALL

4 Answers  

---

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

2 Answers  

---