Skip to Main Content
Forums

APEX

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!

SQL to oracle procedure conversion using outer apply

User_BQO8TNov 18 2020

Hi ,
I am trying to convert a code which is written in SQL to oracle and it is using outer apply in it. But for some reason the outer apply is not working in oracle. I am using oracle 12c. The code which i am converting is:
select * from FROM table1 S1
OUTER APPLY (VALUES (S1.FM46B_PROV_NET_SPEC_P, '1'),
(S1.PROV_NET_SPEC_1,'2'),
(S1.PROV_NET_SPEC_2,'3'),
(S1.PROV_NET_SPEC_3,'4')) PS(PROV_SPEC, SpecType)

I did write the code in oracle using left join and union but it is not working. Could someone please advise me on what needs to be done in-order to write the code using outer apply or using some other way.

Thanks in advance.

Comments

Processing

Post Details

Added on Nov 18 2020
#apex-discussions, #migration, #pl-sql, #procedure, #sql
1 comment
216 views