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.

Oracle

2422

---

How to define an anonymous procedure without variables?

1187

---

What is a schema in oracle?

1063

---

What is logical backup in oracle?

1081

---

Explain the use of grant option in exp command.

1106

---

How to specify default values in insert statement using oracle?

1152

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2061

---

What do you mean by cdb and pdb in oracle 12c?

1099

---

Difference between cartesian join and cross join?

1090

---

What is redo log?

1112

---

definition of cluster and non-clustered index?

3098

---

How many types of synonyms in Oracle?

1175

---

Explain the difference between a procedure and a function?

1236

---

What is the database name in oracle?

1076

---

Hi Can any one tell me what are the API's used in requisition import.

1964

---