Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

how do u setup a replication site?

1991


Explain the use of indexes option in exp command.

1150


Why cursor variables are easier to use than cursors?

1094


What is SQL access advisor in Oracle?

1194


What is data file?

1110


What is the meaning of recursive hints in oracle?

1046


What are the different types of database objects?

1063


What are the types of partitions in oracle?

1038


what is a Nested Loop join?

2119


Is truncate autocommit in oracle?

1087


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2625


How to use "out" parameter properly?

1083


What is primefaces used for?

1049


What is recycle bin in Oracle?

1153


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007