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
What is mdf ldf and ndf?
Does pdo prevent sql injection?
what is bcp? When is it used?
How do I start sql profiler?
what are string data types? : Sql dba
How do temporal tables work?
How do you update f as m and m as f from the below table testtable?
What is difference between sql and excel?
What are the various restrictions imposed on view in terms of dml?
Does execute immediate commit?
What are sql data types?
what are all the common sql function? : Sql dba
What is scope and visibility in PL/SQL?
What is recursive join in sql?
How is a PL/SQL code compiled?
