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 many data types are supported?

1022

---

How to update a table row with a record?

961

---

How do I call oracle stored procedures that take no parameters?

1019

---

How to use subqueries with the in operator using oracle?

1030

---

How to retrieve data from an cursor to a record?

1012

---

What are the limitations of check constraint?

963

---

What is a proxy object?

1008

---

How to use "if" statements on multiple conditions?

1111

---

Explain do view contain data?

940

---

Explain about functional dependency and its relation with table design?

952

---

How to drop an existing table in oracle?

1013

---

In oracle there is column command, how will you explain that?

967

---

Is there a function to split a string in plsql?

981

---

How to create additional tablespaces for an new database?

969

---

Is truncate autocommit in oracle?

1020

---