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).

Answer / guest

Retrives rows in hierarchical order.
e.g. select empno, ename from emp where

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

---

what is not null constraint? : Sql dba

0 Answers  

---

Can we commit inside a trigger?

0 Answers  

---

explain what is mysql? : Sql dba

0 Answers  

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

---

What is rownum?

0 Answers  

---

What is primary key sql?

0 Answers  

---

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

write the Sql query for creating database backup?

7 Answers   TCS,

---

Can I join the same table twice?

0 Answers  

---

how to return query output in html format? : Sql dba

0 Answers  

---