Hi Debasis,
Thanks for your reply.
But my task is not simple.If you read my first mail: I have already done with tree structure using CONNECT BY clause.
I want tree straing with EACH PARENT node repeat in query output.
e.g.
If node 1 has 2 and 3 as child
node 2 has 21 and 22 as child &
node 3 has 31 and 32 as child then
my regular query will return:
child,parent
1,-1
...
KGP
Last Activity: Apr 16 '07, 05:28 AM
Joined: Mar 5 '07
Location:
-
Connect by Clause
Hi ,
I want to write a query which gives me tree structure as each node which has children should be displayed with its entire structure.Let me explain ....
1.I have hierarichal data for which I used connet by clause and I am getting tree structure.
2.Now I want to perform task as(in front end):I will have list of all nodes, I will select any one of node and it should show me tree after that node (considering start with... -
Connect by Clause
Hi ,
I want to write a query which gives me tree structure as each node which has children should be displayed with its entire structure.Let me explain ....
1.I have hierarichal data for which I used connet by clause and I am getting tree structure.
2.Now I want to perform task as(in front end):I will have list of all nodes, I will select any one of node and it should show me tree after that node (considering start with... -
Creating table
I have written one procedure into which I am creating table(Oracle 10g)
While executing procedure I get error as:ORA-01031: insufficient privileges
where as this user has DBA rights and the same SQL statement(Creat e Table) I can execute from SQL-Plus. -
Hierarchical View
Can someone Help me in this?
1. I have one view contains 3 SELECT queries join with UNION
2.All 3 contain START WITH & CONNECT BY
3.This view returns me few rows, If I use filter condition(where clause) then data doesn't get filtered.
4.If I remove START WITH & CONNECT BY from all 3 then it works
OR
Single SELECT query with START WITH & CONNECT BY then it works...
No activity results to display
Leave a comment: