StackOverflow Questions for Tag: connect-by

phareim
phareim

Reputation: 261

Oracle - junction tables and connect to prior

Score: 0

Views: 530

Answers: 1

Read More
Matt Miles
Matt Miles

Reputation: 131

How to migrate Oracle's CONNECT_BY_ISLEAF, CONNECT_BY_ROOT, and CONNECT BY PRIOR to SQL Server?

Score: 0

Views: 44

Answers: 0

Read More
Nick
Nick

Reputation: 11

CONNECT_BY_ROOT Inside of a CONNECT_BY_ROOT

Score: 0

Views: 66

Answers: 1

Read More
Paul Williams
Paul Williams

Reputation: 23

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

Score: 2

Views: 54

Answers: 2

Read More
Nick
Nick

Reputation: 11

Oracle Connect By hierarchy query returns top level parent but child part is null

Score: 1

Views: 95

Answers: 1

Read More
Nick
Nick

Reputation: 11

Oracle help using Connect By Root to return assembly top level parent

Score: 0

Views: 64

Answers: 1

Read More
John Smithv1
John Smithv1

Reputation: 703

Tree Structure with Connect BY inner join and update

Score: 2

Views: 1574

Answers: 1

Read More
Craig
Craig

Reputation: 179

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

Score: 0

Views: 3660

Answers: 1

Read More
Sara Moradi
Sara Moradi

Reputation: 55

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

Score: 1

Views: 17958

Answers: 5

Read More
johnr
johnr

Reputation: 222

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

Score: 0

Views: 32

Answers: 1

Read More
cartbeforehorse
cartbeforehorse

Reputation: 3487

Connect by prior - is this an Oracle bug?

Score: 1

Views: 92

Answers: 2

Read More
stevegrkek
stevegrkek

Reputation: 63

Why oracle constructs cartesian join with 'start with' statement

Score: 0

Views: 64

Answers: 1

Read More
Abhi1988
Abhi1988

Reputation: 179

Oracle sorting connect by prior hierarchically

Score: 1

Views: 17388

Answers: 3

Read More
user2102665
user2102665

Reputation: 505

Using an oracle sequence directly in the CONNECT BY clause

Score: 0

Views: 150

Answers: 0

Read More
mehfuz ayub
mehfuz ayub

Reputation: 11

ORA-01436: CONNECT BY loop in user data in Toad Used by Tab for tables

Score: 1

Views: 1251

Answers: 2

Read More
Lolly
Lolly

Reputation: 36432

Retrieve all children and parents of a given record

Score: 0

Views: 671

Answers: 1

Read More
Landon Statis
Landon Statis

Reputation: 849

Oracle - Connect By Prior

Score: 1

Views: 218

Answers: 2

Read More
Raghav
Raghav

Reputation: 11

CONNECT BY NOCYCLE generating millions of child nodes

Score: 1

Views: 1252

Answers: 1

Read More
Saad
Saad

Reputation: 5

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

Score: 0

Views: 88

Answers: 1

Read More
crkuchlenz
crkuchlenz

Reputation: 33

Snowflake: PRIOR keyword is missing in Connect By statement

Score: 1

Views: 103

Answers: 1

Read More
PreviousPage 1Next