All Questions
Tagged with recursive-query oracle11g
31 questions
0
votes
1
answer
39
views
Is a recursive query possible?
An Oracle SQL question that seems simple to me, but I just can't do it (without manually making several successive queries)... I would like to use a SQL "recursive" approach or any other ...
- 71
5
votes
1
answer
775
views
force Oracle to process recursive CTE on remote db site (perhaps using DRIVING_SITE hint)
I am trying to fetch data from remote table. The data is expanded from seed set of data in local table using recursive CTE. The query is very slow (300 seed rows to 800 final rows takes 7 minutes).
...
- 12.2k
2
votes
1
answer
243
views
Oracle hierarchical SQL - cycle clause or collection of seen elements?
I have undirected and potentially disconnected graph represented as table of edges.
I need to return list of all edges reachable from given initial set of edges.
This is common task which can be found ...
- 12.2k
1
vote
3
answers
118
views
How to get root of hierarchial joined data in oracle 11g
My schema looks like this.
I've got hierarchial districts:
create table district(
id integer primary key,
name varchar2(32),
parent_id integer references district(id)
)
And houses within ...
- 1,630
0
votes
1
answer
33
views
Single Column recursive query Output
Can anybody please help me out on below query output based on below tabular data.
Pattern : AVRA1 is linked with 979798. now in 979798 we have (AVRA1,SHUBH2,MOM). Now SHUBH2 is linked 979798,979799. ...
- 3,303
0
votes
0
answers
397
views
What columns form cycle in this "ORA-32044: cycle detected while executing recursive with query" error?
I have recursive query on table with undirected graph data. Data is represented as table of edges (Oracle 11g). The recursive query traverses all edges starting from given edge. The idea of query is: ...
- 12.2k
1
vote
2
answers
65
views
How to create a view that dynamically fills in missing rows of data from a table
I'm looking to create a view that dynamically fills in missing rows of data from a source test_table. The source test_table updates when changes have been made & the latest record is marked by a ...
- 511
1
vote
1
answer
113
views
ORA-00932 if collection used in recursive CTE in where clause
I have recursive CTE with column of collection type (sys.ku$_vcnt is used here because it is built-in, problem can be reproduced for any collection type). When the collection column is used in ...
- 12.2k
2
votes
2
answers
222
views
Convert 1 column to 2 columns in Oracle SQL
We get the data in the following format which I am able to convert using Regular expression query. The data is start and end data of tasks concatenated with pipe.
Data:
|2020/04/26|2020/05/02|2020/...
0
votes
1
answer
78
views
Find all dependencies between customers with recursive query ORACLE 11G
I'm trying to write a recursive CTE to give me all of the other customers a "primary customer" depends on, but I don't know where to start.
I have created a sample data set and table structure:
...
- 11
-1
votes
1
answer
3k
views
How to get all levels data using single SQL query for bill of material
I have a lot of bill of material Items and it contains their raw material and semi-finished goods. The semi-finished goods have their own bill of material with raw material and further semi-finished ...
- 307
3
votes
1
answer
506
views
How to create duplicate rows based on a column values [duplicate]
I need to duplicate resulted rows based on a column value.
I already read a few posts like this, but I wasn't able to translate this so it would work on my oracle database.
I got two tables. The ...
- 33
0
votes
1
answer
943
views
Recursive query in Oracle to find children and sibling
I'm struggling a hierarchical SQL query. I want to have another 2 columns of the disp_order of its children and sibling.
Children - Should hold all disp_order of their child and their grand children ...
- 426
1
vote
1
answer
310
views
how to get relations family
I have these tables
person table with following data
person_id description
1 first in the family
2 SON OF PERSON 1
3 SON OF PEROSN 2
4 SON OF PEROSN 3
5 ...
- 15
0
votes
1
answer
286
views
how to get the whole name of person from database
I have these tables
person table with following data
person_id description
1 first in the family
2 second in the family
3 third in the family
4 fourth ...
- 15