Home » SQL & PL/SQL » SQL & PL/SQL » Level pseudocolumn
Level pseudocolumn [message #231164] Sun, 15 April 2007 06:31 Go to next message
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member

Please explain what is LEVEL pseodocolumn with example

Select EMPNO
From EMP
Start With EMPNO = 7839
Connect By Prior empno = mgr
/
EMPNO
----------
7839
7566
7788
7876
7902
7369
7698
7499
7521
7654
7844
7900
7782
7934

Please explain me above output

The data in EMP table is as follows
SQL> select empno,ename,mgr from emp1;

EMPNO ENAME MGR
---------- ------------ ----------
7369 SMITH 7902
7499 ALLEN 7698
7521 WARD 7698
7566 JONES 7839
7654 MARTIN 7698
7698 BLAKE 7839
7782 CLARK 7839
7788 SCOTT 7566
7839 KING
7844 TURNER 7698
7876 ADAMS 7788
7900 JAMES 7698
7902 FORD 7566
7934 MILLER 7782
Re: Level pseudocolumn [message #231170 is a reply to message #231164] Sun, 15 April 2007 07:10 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read SQL Reference.
You post 4 questions in a couple of minutes, you'd get 4 answers in the documentation if only you were not too lazy to make a search.

You said in your profile "Hungry for knowledge" but knowlegde is in book.
And first thing to read before posting is the chart.
If you even can't do that, I doubt you can get any knowledge and even I can't trust you are hungry for that.

Regards
Michel

[Updated on: Sun, 15 April 2007 07:12]

Report message to a moderator

Previous Topic: previliges
Next Topic: Check previlage on a folder/file
Goto Forum:
  


Current Time: Mon Dec 05 09:17:24 CST 2016

Total time taken to generate the page: 0.04926 seconds