Рет қаралды 439
From basic concepts about recursive SQL like CONNECT BY, COMMON TABLE Expression (CTE) this video covers all you need to know about recursive SQL.
You will write your first CONNECT BY SQL, and understand how it works. The START WITH and CONNECT BY PRIOR clauses are explained.
You will learn :
The use of LEVEL pseudo column in recursive SQL.
The ORDER SIBLINGS BY clause, SYS_CONNECT_BY_PATH, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, NOCYCLE and CONNECT_BY_ISCYCLE