如何查詢出現(xiàn)機(jī)構(gòu)和其屬下所有機(jī)構(gòu)?
試試這個(gè) select orgid,fatherorgid,orgname from gias_org start with orgid = 1 connect by prior id = fatherorgid
如何查詢出現(xiàn)機(jī)構(gòu)和其屬下所有機(jī)構(gòu)?
試試這個(gè) select orgid,fatherorgid,orgname from gias_org start with orgid = 1 connect by prior id = fatherorgid