Urgent !! PLease HElp [message #19876] |
Mon, 15 April 2002 21:12 |
rajesh
Messages: 173 Registered: November 1998
|
Senior Member |
|
|
Start with Key Word (When using Connect by Prior)
is Working with Select clause while Accessing a Remote Database but when the Result of the above Select statement is inserted into a table in local d/b It's Not Working..
Can anyone Suggest a Solution Or tell us What's Wrong that We r doing?
Following is the Actual Query.
insert into provision_grid_temp (grid_id,sub_grid_id,depth)
SELECT ts.pg_sequence_num grid_id,
ts.psg_sequence_num sub_grid_id,
LEVEL depth
FROM tgrsub ts
CONNECT BY PRIOR
ts.pg_sequence_num = ts.psg_sequence_num
START WITH ts.psg_sequence_num IN (SELECT pg_sequence_num FROM tgrid WHERE LENGTH(pg_name) = 4
AND pg_sequence_num NOT IN (SELECT pg_sequence_num FROM tgrsub))
|
|
|
Re:Try this, [message #19884 is a reply to message #19876] |
Tue, 16 April 2002 04:26 |
P.Deshmukh
Messages: 17 Registered: March 2002
|
Junior Member |
|
|
Pl. try this, First create a view by Same query.
Insert the rows from this view to ur provision_grid_temp table.
create view vw_provision_grid_temp
as
SELECT ts.pg_sequence_num grid_id,
ts.psg_sequence_num sub_grid_id,
LEVEL depth
FROM tgrsub ts
CONNECT BY PRIOR
ts.pg_sequence_num = ts.psg_sequence_num
START WITH ts.psg_sequence_num IN (SELECT pg_sequence_num FROM tgrid WHERE LENGTH(pg_name) = 4
AND pg_sequence_num NOT IN (SELECT pg_sequence_num FROM tgrsub))
|
|
|