Answer Posted / saraswathi muthuraman

SQL> explain plan for select * from dual;

Explained.

SQL> select
substr (lpad(' ', level-1) || operation || ' (' || options
|| ')',1,30 ) "Operation",
object_name
"Object"
from
plan_table
start with id = 0
connect by prior id=parent_id;


SELECT STATEMENT ()
TABLE ACCESS (FULL)
DUAL

2 rows selected.

material view and view disadvantages?

633

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1694

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1801

---

if you ctreate table identity

1843

---

What is index-organized table in Oracle?

565

---

---

How to create tables for odbc connection testing?

485

---

How do I spool to a csv formatted file using sqlplus?

541

---

What are the common oracle dba tasks?

617

---

How to invoke the original export import utilities?

503

---

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

585

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2173

---

What is the difference between Delete, Truncate and Drop in Oracle?

602

---

What are the uses of synonyms?

598

---

What are triggers in oracle?

553

---

Does oracle database need java?

518

---