Retrives rows in hierarchical order. e.g. select empno, ename from emp whe

Explain Connect by Prior?

Question Posted / guest

Answer Posted / guest

Retrives rows in hierarchical order.
e.g. select empno, ename from emp where

Is This Answer Correct ?

6 Yes

16 No

Please Help Members By Posting Answers For Below Questions

What is a memo field?

1015

how to check server status with 'mysqladmin'? : Sql dba

1131

What are the qualities of 2nf?

1095

Explain scalar functions in sql?

1103

what are myisam tables? : Sql dba

1077

Can we use rowid as primary key?

1042

How delete all data from all tables in sql?

983

Explain cursor types?

1081

what is a database? : Sql dba

1238

what are the differences among rownum, rank and dense_rank? : Sql dba

1085

What is trigger in sql? Explain

1040

What are different clauses used in sql?

1172

Can we insert in sql function?

1140

How do I quit sql?

1005

what are aggregate and scalar functions? : Sql dba

1104