关于等级查询和lpad:
SELECTlpad (last_name||' reports to '||PRIOR last_name ,length( last_name||' reports to '||PRIOR last_name)+level *4-4,'_') "Walk Top Down"
FROM employees
START WITHemployee_id= 100
CONNECT BY PRIOR employee_id = manager_id ;
页:
[1]