Question

Oracle CONNECT BY when one of multiple columns can be parent id

score 28 · Answer 1 · 2024-02-16T16:43:59.087000

28

Views

Oracle CONNECT BY when one of multiple columns can be parent id

Published on 16 February 2024 at 16:43

score 67 · Answer 2 · 2024-01-11T15:14:16.883000

67

Views

Connect by prior - is this an Oracle bug?

Published on 11 January 2024 at 15:14

score 103 · Answer 3 · 2023-12-19T07:57:19.513000

103

Views

Why oracle constructs cartesian join with 'start with' statement

Published on 19 December 2023 at 07:57

score 71 · Answer 4 · 2023-10-03T15:16:53.883000

71

Views

Using an oracle sequence directly in the CONNECT BY clause

Published on 03 October 2023 at 15:16

score 43 · Answer 5 · 2023-06-20T06:15:55.057000

43

Views

Using columns from two different tables in connect by prior clause in SQL

Published on 20 June 2023 at 06:15

score 77 · Answer 6 · 2023-04-12T23:26:50.597000

77

Views

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

Published on 12 April 2023 at 23:26

score 74 · Answer 7 · 2023-04-12T17:41:55.803000

74

Views

Snowflake: PRIOR keyword is missing in Connect By statement

Published on 12 April 2023 at 17:41

score 146 · Answer 8 · 2023-01-23T15:18:01.650000

146

Views

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

Published on 23 January 2023 at 15:18

score 117 · Answer 9 · 2023-01-19T18:25:49.130000

117

Views

Oracle SQL Connect By Level - literal does not match format string

Published on 19 January 2023 at 18:25

score 28 · Answer 10 · 2022-11-08T03:31:35.760000

28

Views

Get Ultimate manager oracle

Published on 08 November 2022 at 03:31

score 108 · Answer 11 · 2022-08-22T07:23:59.463000

108

Views

Formatting a hierarchical query in a nested tree syntax (Oracle)

Published on 22 August 2022 at 07:23

score 828 · Answer 12 · 2022-08-04T18:32:10.020000

828

Views

Oracle: Trying to split a string using REGEXP_SUBSTR, CONNECT BY LEVEL functions and getting duplicates

Published on 04 August 2022 at 18:32

score 128 · Answer 13 · 2022-07-05T15:04:47.323000

128

Views

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

Published on 05 July 2022 at 15:04

score 174 · Answer 14 · 2022-07-05T12:28:28.760000

174

Views

Multi column hierarchical query in Oracle SQL

Published on 05 July 2022 at 12:28

score 93 · Answer 15 · 2022-04-28T14:06:20.950000

93

Views

I need to convert this query from Oracle to SQL Server

Published on 28 April 2022 at 14:06

score 423 · Answer 16 · 2022-04-26T19:32:25.277000

423

Views

Oracle INSERT and CONNECT by

Published on 26 April 2022 at 19:32

score 110 · Answer 17 · 2022-02-21T21:49:31.237000

110

Views

Expanding Oracle rows with comma-delimited values into multiple rows

Published on 21 February 2022 at 21:49

score 67 · Answer 18 · 2021-11-04T11:45:20.817000

67

Views

Parameterising a START WITH / CONNECT BY query

Published on 04 November 2021 at 11:45

score 9.5k · Answer 19 · 2021-09-08T08:55:09.293000

9.5k

Views

Oracle - using connect by prior in Hierarchical Queries and put them into rows

Published on 08 September 2021 at 08:55

score 420 · Answer 20 · 2021-08-28T21:55:39.687000

420

Views

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

Published on 28 August 2021 at 21:55

List Question

Oracle CONNECT BY when one of multiple columns can be parent id

Connect by prior - is this an Oracle bug?

Why oracle constructs cartesian join with 'start with' statement

Using an oracle sequence directly in the CONNECT BY clause

Using columns from two different tables in connect by prior clause in SQL

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

Snowflake: PRIOR keyword is missing in Connect By statement

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

Oracle SQL Connect By Level - literal does not match format string

Get Ultimate manager oracle

Formatting a hierarchical query in a nested tree syntax (Oracle)

Oracle: Trying to split a string using REGEXP_SUBSTR, CONNECT BY LEVEL functions and getting duplicates

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

Multi column hierarchical query in Oracle SQL

I need to convert this query from Oracle to SQL Server

Oracle INSERT and CONNECT by

Expanding Oracle rows with comma-delimited values into multiple rows

Parameterising a START WITH / CONNECT BY query

Oracle - using connect by prior in Hierarchical Queries and put them into rows

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

Trending Questions

Popular # Hahtags

Popular Questions