Answer / 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.

Answer / venkateswararao

from dual?

What is oracle database client?

1 Answers  

---

what is the difference between functional dependecy and multilevel dependency?

1 Answers   Oracle,

---

what is trigger?

6 Answers   Oracle,

---

Which is better Oracle or MS SQL? Why?

3 Answers   Bally Technologies,

---

How to create index-by table in oracle?

3 Answers  

---

How different is ms access and oracle?

1 Answers  

---

What is tns service name?

1 Answers  

---

Name the three major set of files on disk that compose a database in Oracle?

1 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,

---

what happened to the global index when I truncate the data in one of the partition?

1 Answers  

---

SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>

1 Answers   Infosys,

---

structural difference between bitmap and btree index ?

1 Answers   Infosys,

---