Answer Posted / bibhu

select new_no as new_noz
from t01
union
select old_no as new_noz
from t01
order by new_noz

What are pl/sql cursors?

555

---

Why do we need cursor in pl sql?

637

---

How to start the command-line sql*plus?

557

---

Does oracle roll back the transaction on an error?

524

---

explain normalization concept? : Sql dba

577

---

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

1998

---

What are the types of join in sql?

512

---

What is a memo field?

517

---

Is sql sequential or random?

529

---

What is data manipulation language?

686

---

What is the difference between cross join and natural join?

554

---

what is recursive stored procedure? : Sql dba

520

---

Can you sum a count in sql?

545

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

544

---

When you have to use a default "rollback to" savepoint of plvlog?

709

---