SQL 迭代查詢語句

標籤：ati   nbsp   from   span   parent   sele   pl/sql   use   sel   

SQL迭代查詢 PL/SQL

with ORG_Tree(ObjectId,parentID) as(    select a.ObjectId,a.parentID from Ot_Organizationunit a where Name in (‘212江蘇地區‘,‘225浙江地區‘,‘260蘇州地區‘,‘217滬蘇地區‘)    Union ALL    select b.ObjectId,b.parentID from Ot_Organizationunit b inner join ORG_Tree T on b.parentID=T.ObjectID)select ouser.Name,ouser.code from OT_User ouser inner join ORG_Tree ot on ouser.parentid=ot.ObjectID

 

SQL 迭代查詢語句