Forum Stats

  • 3,770,488 Users
  • 2,253,125 Discussions
  • 7,875,484 Comments

Discussions

Creating View WITH clause Issue

User_JZKI6
User_JZKI6 Member Posts: 38 Green Ribbon

Hi Everyone,

We created table using below code and its working

with Table_A AS

(select C1,c2,C3,C4,C5,C6..

from

(select C1,C2,C3,C4

from

(select C1,C2,

from Table_B B,Table_C C

)))

select B.c1,B.c2,C.C4,C.C5

from Table_A,Table_B B,Table_C C

Now we are trying to create View on top of the above query we used below syntax.

create or replace view V1 as

(

with Table_A AS

(select C1,c2,C3,C4,C5,C6..

from

(select C1,C2,C3,C4

from

(select C1,C2,

from Table_B B,Table_C C

)))

select B.c1,B.c2,C.C4,C.C5

from Table_A,Table_B B,Table_C C

)

select * from Table_A;


getting below error can someone suggest.


Tagged:

Answers