Connect by prior can be used to create heirarchical tree structure

pls explain connect by prior with example and its real time
use

Question Posted / muhammed zaheer

Answer Posted / muhammed zaheer

Connect by prior can be used to create heirarchical tree
structure

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain the use of owner option in exp command.

1048

How to put more than 1000 values into an oracle in clause?

1034

What happens if variable names collide with table/column names?

1196

Explain compound trigger in oracle?

1047

How to update a table row with a record?

1016

What is a parameter file in oracle?

1137

What privilege is needed for a user to query tables in another schema?

973

Name the various constraints used in oracle?

1023

What is an oracle?

1022

What are the data types in oracle?

1043

How to view existing locks on the database?

1056

What is the scope of a local variable?

1067

What is system tablespace?

1102

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2400

How to rename an index?

1076