Search code examples
How to deal with a NULL in Connect By Level without the query going on forever?...


sqloracleconnect-by

Read More
Access parent alias in subquery within a with clause using connect by in Oracle...


sqloraclenestedconnect-byora-00904

Read More
Connect by prior - is this an Oracle bug?...


sqloracleconnect-by

Read More
Retrieve all children and parents of a given record...


sqloracleconnect-by

Read More
How to improve processing time for queries that use CONNECT BY and LEVEL clause...


sqloracleconnect-by

Read More
Snowflake: PRIOR keyword is missing in Connect By statement...


stored-proceduressnowflake-cloud-data-platformconnect-by

Read More
Oracle Hierarchical queries: Translate START WITH ... CONNECT BY PRIOR into 'Recursive Subquery ...


oraclehierarchical-datarecursive-queryconnect-by

Read More
What is the equivalent PostgreSQL syntax to Oracle's CONNECT BY ... START WITH?...


sqloraclepostgresqlrecursive-queryconnect-by

Read More
Oracle: Trying to split a string using REGEXP_SUBSTR, CONNECT BY LEVEL functions and getting duplica...


sqloracleselectregexp-substrconnect-by

Read More
Why does deterministic function return unexpected numbers in CONNECT BY LEVEL query?...


sqloracledeterministicoracle18cconnect-by

Read More
I need to convert this query from Oracle to SQL Server...


sql-serveroracleconnect-byrecursive-cte

Read More
Oracle INSERT and CONNECT by...


oraclestored-functionsconnect-by

Read More
Expanding Oracle rows with comma-delimited values into multiple rows...


oracleconnect-by

Read More
SQL Connect By Level sometimes works, sometimes doesn't can't understand why...


sqloracleoracle11gconnect-by

Read More
Given any child in the hierarchy, fetch complete tree by INFORMIX hierarchical SQL...


sqlinformixconnect-by

Read More
NOCYCLE in Postgres...


sqloraclepostgresqlconnect-by

Read More
Display immediate parent after CONNECT_BY_ROOT in Oracle PL SQL...


sqloracleconnect-by

Read More
Use connect by by in REGEXP_SUBSTR without breaking result to multiple rows...


regexoracleregexp-substrconnect-by

Read More
Is there any to add one loop row in connect by oracle with nocycle?...


oracleconnect-by

Read More
Extract a sub-tree from a hierarchy tree based on a leaf in Oracle...


oracletreehierarchical-dataconnect-by

Read More
Oracle Recursive Query Connect By Loop in data...


sqloracleloopsrecursionconnect-by

Read More
hierarchical query without side rows...


sqloracleconnect-byhierarchical-query

Read More
Oracle SQL - Generate rows based on quantity column...


sqloraclerowconnect-by

Read More
Hierarchical query with some joins...


sqloracleconnect-by

Read More
connect-by-prior: using PRIOR to drill 2-levels up...


sqloracleconnect-by

Read More
SQL Server Equivalent of Oracle 'CONNECT BY PRIOR', and 'ORDER SIBLINGS BY'...


sql-serveroraclerecursive-querysiblingsconnect-by

Read More
Redirect postgres connectby into a table...


sqlpostgresqlsql-insertcreate-tableconnect-by

Read More
SQL Recursive Queries , problems with understanding "prior" expression on connect by claus...


sqlhierarchyrecursive-queryconnect-by

Read More
Oracle SQL Recursive Query When FieldType is Subpage...


sqloracleconnect-by

Read More
Hierarchical query with reference to previous row, not parent row...


sqloraclerecursive-queryconnect-by

Read More
BackNext