pls explain connect by prior with example and its real time
use

Answer Posted / muhammed zaheer

Connect by prior can be used to create heirarchical tree
structure

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain coalesce function?

617


What is merge in oracle?

550


What are the differences between blob and clob in oracle?

576


What is clustered table in Oracle?

633


How do I connect to oracle database?

529






I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

1967


What are the attributes of the cursor?

549


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1652


Explain about the analyze command in oracle?

573


How to generate query output in html format?

558


What is meant by raw datatype?

555


What are the general rules on data consistency?

576


How many types of synonyms in Oracle?

585


List the various oracle database objects?

592


How to store pictures on to the database?

520