Answer Posted / mamta

select rownum as maxsal,sal
from (select sal from emp order by sal desc)
where rownum <4

How to delete all rows a table in oracle?

621

---

How to view existing locks on the database?

547

---

How can you use check constraints for self referential integrity?

520

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

524

---

What is ordinary table in oracle?

652

---

---

Explain the use of grant option in exp command.

586

---

How can I get column names from a table in oracle?

534

---

Explain the use of tables option in exp command.

591

---

What privilege is needed for a user to create views in oracle?

587

---

What is the minimum client footprint required to connect c# to an oracle database?

563

---

if you ctreate table identity

1847

---

What is the data pump import utility?

581

---

What is a user role in oracle?

613

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1805

---

What is an oracle cursor variable?

607

---