Interested to Buy Any Domain ? << Click Here >> for more details...
pls explain connect by prior with example and its real time
use
- 3 Answers
- 14362 Views
- I also Faced
- E-Mail Answers
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 to convert times to characters in oracle?
What do you mean by a tablespace?
What is an oracle tablespace?
What are the ways tablespaces can be managed and how do they differ?
Explain an index?
Give the advantages and disadvantages of clusters.
Difference between varchar and varchar2 data types?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is oracle in java?
Can we use bind variables in oracle stored procedure?
Why do we need integrity constraints in a database?
What is the difference between substr & instr functions?
What is snapshot is too old? Give and example for better understand.
How to connect the oracle server as sysdba?
What is a read write transaction in oracle?
