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!

ORA-32034

Hello
I can not create a view
best regards

create view deneme1 as
(
with we_have (a_value) as ( select 100000 from dual)
select po_number,id, ALINAN_ADET,
a_value + sum(ALINAN_ADET) over (order by id) - ALINAN_ADET + 1 as q_start,
a_value + sum(ALINAN_ADET) over (order by id) as q_stop
from purchase cross join we_have
)

ORA-32034: desteklenmeyen WITH yan tümcesi kullanımı
ORA-06512: konum "SYS.WWV_DBMS_SQL_APEX_200200", satır 626
ORA-06512: konum "SYS.DBMS_SYS_SQL", satır 1658
ORA-06512: konum "SYS.WWV_DBMS_SQL_APEX_200200", satır 612
ORA-06512: konum "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", satır 1749

Comments
Post Details
Added on Mar 30 2021
3 comments
162 views