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
how do u setup a replication site?
Explain the use of indexes option in exp command.
Why cursor variables are easier to use than cursors?
What is SQL access advisor in Oracle?
What is data file?
What is the meaning of recursive hints in oracle?
What are the different types of database objects?
What are the types of partitions in oracle?
what is a Nested Loop join?
Is truncate autocommit in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to use "out" parameter properly?
What is primefaces used for?
What is recycle bin in Oracle?
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.