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.

How to connect the oracle server as sysdba?

1063

---

Difference between pre-select and pre-query

1081

---

Is there an oracle sql query that aggregates multiple rows into one row?

963

---

How does one get the view definition of fixed views/tables?

1003

---

What is rowid and rownum in oracle?

995

---

What is control file used for?

1178

---

What is the difference between postgresql and oracle?

1021

---

What is define in oracle?

1045

---

What is system tablespace?

1077

---

How to export several tables together?

1032

---

What is query image?

967

---

What is different types of joins?

1007

---

What is a static data dictionary in oracle?

1083

---

How to enter a new row into a table interactively?

994

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2139

---