Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / abhijit
The start with .. connect by clause can be used to select
data that has a hierarchical relationship (usually some sort
of parent->child (boss->employee or thing->parts).
select a.*, level from emp a
start with mgr is null
connect by mgr = prior empno;
The start with .. connect by clause can be used to select
data that has a hierarchical relationship (usually some sort
of parent->child (boss->employee or thing->parts).
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
Is sql low level language?
How do you write a complex sql query?
Is sql workbench free?
Does oracle roll back the transaction on an error?
what are the features and advantages of object-oriented programming? : Sql dba
What is the use of count (*) in sql?
What is embedded sql in db2?
what are the differences between char and nchar? : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Which command is used to call a stored procedure?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is rowtype?
What is a table partition?
Is it possible to create startup or shutdown trigger for on-schema?
Does truncate table reset auto increment?
