Interested to Buy Any Domain ? << Click Here >> for more details...
Explain Connect by Prior?
- 2 Answers
- 12032 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
Retrives rows in hierarchical order.
e.g. select empno, ename from emp where
| Is This Answer Correct ? | 6 Yes | 16 No |
Which data dictionary views have the information on the triggers that are available in the database?
What is the difference between alter trigger and drop trigger statements?
What are different clauses used in sql?
What is a variable in sql?
Can dml statements be used in pl/sql?
How many LONG columns are allowed in a table?
What are inner outer left and right joins in sql?
Delete the emps whose salaries are lowest sals of their own dept.
How many tables can a sql database have?
What is difference sql and mysql?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is a scalar value in sql?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
