Home » SQL & PL/SQL » SQL & PL/SQL » connect and level (sql developer)
connect and level [message #652747] Fri, 17 June 2016 15:07 Go to next message
nath123
Messages: 19
Registered: May 2016
Location: united states
Junior Member
Hi all

Could you please suggest what does connect by
Trying to understand about this .

SELECT Lpad(last_name,Length(last_name) + LEVEL * 10 - 10,'-') 
,level from employees
where level<=3
start with manager_id is null
connect by prior manager_id =employee_id;
(or)
connect by prior employee_id= manager_id;
Re: connect and level [message #652748 is a reply to message #652747] Fri, 17 June 2016 15:10 Go to previous message
Solomon Yakobson
Messages: 3104
Registered: January 2010
Location: Connecticut, USA
Senior Member
Hierarchical Queries

SY.
Previous Topic: What is the use of %ROWTYPE and %TYPE in PL/SQL?
Next Topic: LAG function
Goto Forum:
  


Current Time: Sat Dec 04 04:29:39 CST 2021