Why do you create or replace procedures rather that drop and recreate.

0 Answers  

---

hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,

---

waht is the difference between primary key and super key?

9 Answers  

---

How to use select statement to count the number of rows in oracle?

0 Answers  

---

What is difference between SQL and SQL*PLUS?

1 Answers  

---

Define the terms primary key foreign key and also the difference between primary and the unique key

2 Answers  

---

How many memory layers are in the oracle shared pool?

0 Answers  

---

why pl sql doesn't support retrieving multiple records

1 Answers   Mphasis,

---

What is Redo Log Buffer in Oracle?

0 Answers   MCN Solutions,

---

waht is referencial integrity?

2 Answers   Semantic Space,

---

Explain the difference between replace() and translate() functions in oracle?

0 Answers  

---

How to select some columns from a table in oracle?

0 Answers  

---