Sub Query and Case Statements
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