[Oracle] display connect by, oracleconnect

[Oracle] display connect by, oracleconnect

 

1. Display by organizational structure relationship

Create or replace view v_vieworg
Select -- v. OBJID, v. OBJNAME
Level as levelid,
Lpad ('', 2 * level-2) | v. OBJNAME as OBJNAME, v. OBJID, v. OBJCODE, v. ISDEPT, v. PARENTAREAID, v. PARENTDEPTID, v. parentID, v. canceled
From v_organddept v
Start with v. OBJID = 100001
Connect by prior v. OBJID = v. ParentID;

 

Usage of oracle connect by and start

Recursive query, which is very effective when the data structure is tree and linked list.
For example, menus and organizations.

Why does the connect by Loop Error in user data prompt during oracle SQL query?

It is estimated that your data is like
The parent of 1 is 2, and the parent of 2 points to 1 again, resulting in an endless loop.