Forum Stats

  • 3,769,356 Users
  • 2,252,953 Discussions
  • 7,874,996 Comments

Discussions

SQL to oracle procedure conversion using outer apply

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.

Answers