pls explain connect by prior with example and its real time
use
Answer Posted / simi
CONNECT BY PRIOR is used for tree-structured queries.
I found a simple & useful explanation here:
http://www.oraclepassport.com
SQL - CONNECT By PRIOR Section
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Calculate difference between 2 date / times in oracle sql?
query optmization techniques and quwry analyser+projects+ppts
How does the on-delete-cascade statement work?
What is oracle datasource?
How to convert numbers to characters in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
does the query needs a hint to access a materialized view?
Why does for update in oracle 8 cause an ora-01002 error?
Explain the use of indexes option in exp command.
What is blob datatype?
Difference between varchar and varchar2 data types?
Explain about the analyze command in oracle?
How to assign values to variables?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Why oracle is used?