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 does the acronym acid stand for in database management?

1018

What is a constraint?

997

What is before trigger?

984

Can we use join in subquery?

1073

What is date functions?

1013

Is inner join same as self join?

1107

Does sql profiler affect performance?

975

what is the difference between group by and order by in sql? : Sql dba

1104

What is program debugging?

1215

What is sql trigger example?

1029

when is the use of update_statistics command? : Sql dba

1025

What is the difference between python and sql?

972

How many subqueries can be nested in a statement?

971

How to connect a sql*plus session to an oracle server?

1111

Is sql a backend language?

1073