Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating View WITH clause Issue

User_JZKI6May 12 2021

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.
Error.PNG

Comments

Tércio Costa

Uma simples solução seria fazer 3 vezes o join na tabela  flp_documentos, uma vez para cada um dos tipos de documentos citados, e assim você retornaria cada um desses elementos no seu select list.

1 - 1

Post Details

Added on May 12 2021
1 comment
245 views