You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Sub Query and Case Statements

edited Feb 9, 2021 10:19PM in Idea Lab – Integration Cloud

Description

Provide support for writing sub queries and case statements in OIC DB adapter.

Use Case and Business Need

During our migration of Oracle SOA code to OIC. there are SQL statements for eg: select a,b,c from table1 where x in (select y from table2) and select statement with CASE clause were written, but in OIC these are not supported. workaround is to create PLSQL procedures.

Original Idea Number: cb6bf7330b
Tagged:
1
Up Down
1 votes

Submitted · Last Updated

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!