Answer Posted / tanuj tewari

select max(sal) from table_name where sal<(select max(sal)
from table_name);

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?

1533

---

How to check database size in Oracle?

644

---

What is logical backup in oracle?

580

---

How to best split csv strings in oracle 9i?

597

---

How to rollback the current transaction in oracle?

544

---

---

how can we store any pdf file in oracle

1648

---

How to get execution statistics reports on query statements?

572

---

Can we write dml statement in function in oracle?

638

---

Why is oracle so popular?

567

---

How to create a stored program unit?

583

---

What is oracle database 10g express edition?

604

---

What are the various constraints used in oracle?

556

---

How oracle handles dead locks?

606

---

State and explain the different types of data models?

538

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

572

---