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!

with tab as

Rosario VigilanteJun 5 2019 — edited Jun 6 2019

Hello

How ca I write a with as having EXCEPTION, that is

FOR R_PLAN_ACCESS IN (

      with time_tab (x1, x2   )

       as (

begin

select

....

EXCEPTION

WHEN NO_DATA_FOUND THEN

...

end

),

, iterator(hours)  as (

..

Thanks in advance

This post has been answered by Cookiemonster76 on Jun 6 2019
Jump to Answer
Comments
Post Details
Added on Jun 5 2019
11 comments
2,554 views