Search code examples
Oracle - junction tables and connect to prior...

oracle-databasehierarchical-dataconnect-by

Read More
How to deal with a NULL in Connect By Level without the query going on forever?...

sqloracle-databaseconnect-by

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

sqloracle-databasenestedconnect-byora-00904

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

sqloracle-databaseconnect-by

Read More
Why oracle constructs cartesian join with 'start with' statement...

sqloracle-databasejoinconnect-by

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

sqloracle-databaseconnect-by

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

sqloracle-databaseconnect-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 ...

oracle-databasehierarchical-datarecursive-queryconnect-by

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

sqloracle-databasepostgresqlrecursive-queryconnect-by

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

sqloracle-databaseselectregexp-substrconnect-by

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

sqloracle-databasedeterministicoracle18cconnect-by

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

sql-serveroracle-databaseconnect-byrecursive-cte

Read More
Oracle INSERT and CONNECT by...

oracle-databasestored-functionsconnect-by

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

oracle-databaseconnect-by

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

sqloracle-databaseoracle11gconnect-by

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

sqlinformixconnect-by

Read More
NOCYCLE in Postgres...

sqloracle-databasepostgresqlconnect-by

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

sqloracle-databaseconnect-by

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

regexoracle-databaseregexp-substrconnect-by

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

oracle-databaseconnect-by

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

oracle-databasetreehierarchical-dataconnect-by

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

sqloracle-databaseloopsrecursionconnect-by

Read More
hierarchical query without side rows...

sqloracle-databaseconnect-byhierarchical-query

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

sqloracle-databaserowconnect-by

Read More
Hierarchical query with some joins...

sqloracle-databaseconnect-by

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

sqloracle-databaseconnect-by

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

sql-serveroracle-databaserecursive-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
BackNext