Interested to Buy Any Domain ? << Click Here >> for more details...
pls explain connect by prior with example and its real time
use
- 3 Answers
- 14419 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 raw datatype?
How to drop an existing table in oracle?
Is there any function in oracle similar like group_concat of mysql?
What are dml statements in oracle?
Can we insert data in view oracle?
Explain what are the uses of rollback segment?
Define oracle database
what are the default admin accounts in Oracle 10g ?
How will you identify oracle database software release?
How to save query output to a local file?
How to recover a dropped table in oracle?
How do we display rows from the table without duplicates?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What do you mean by group by clause?
Explain what are the different type of segments?
