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
What is embedded sql with example?
What are all the different normalization?
What is dml with example?
Is ms sql is free?
Which type of cursor is used to execute the dml statement?
what are all the different types of indexes? : Sql dba
what are the features and advantages of object-oriented programming? : Sql dba
What does where 1 1 mean in sql?
how to create a test table in your mysql server? : Sql dba
What is the current version of sql?
What are the three pl sql block types?
What is a sql statement?
How global cursor can be declare with dynamic trigger ?
Explain the the delete statements in sql?
How can we implement rollback or commit statement in a trigger?
