Interested to Buy Any Domain ? << Click Here >> for more details...
pls explain connect by prior with example and its real time
use
- 3 Answers
- 14494 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
What is Library Cache in Oracle?
What is a tns file?
How do I start tns listener?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to lock and unlock a user account in oracle?
what is reindexing?
How to speed up webrick?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
what are actual and formal parameters?
How to view the tablespaces in the current database?
How to best split csv strings in oracle 9i?
does the query needs a hint to access a materialized view?
What is a Garbage Collection? and what is full recursive Garbage collection?
Which is better Oracle or MS SQL? Why?
How to convert characters to times in oracle?
