Interested to Buy Any Domain ? << Click Here >> for more details...
pls explain connect by prior with example and its real time
use
- 3 Answers
- 14644 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 the data type of dual table?
What is the difference between alert log file and tarce file ?
What do you mean by group by clause?
What is the oracle implicit cursor?
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.
How do I escape a reserved word in oracle?
What is the string concatenation operator in oracle?
How to work with data objects interactively?
How to use an explicit cursor without open statements?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How to add a new column to an existing table with a default value?
How to drop an existing table in oracle?
Why do we need integrity constraints in a database?
How would you change old and new values in an insert, delete and update triggers?
How to store pictures on to the database?
