Skip to Content
0
Former Member
Feb 19, 2009 at 07:33 AM

NestedSlects In Select Staments with clubbing of 5 tables with Order Clause

15 Views

Hi Experts,

I need to execute on Oracle Qurey in Receiver JDBC.

The oracle select Query contains

1. Many Select statments in the parent select statment

2. In side child select stament there are standard SQL fiunctions like.. NVL()

3. Parent select statements is operating on 5 tables...

4. There is big where clause, in side the where clause thare are some more select statments and standard SQL functions

5. It has order by caluse as well.

On total, it was a full pledged SQL Select statment, which has all types and varieties of twists in side it.

Clinet is not agreeing for Stored Procedure. He just want to execute Big Select statment form XI and get back the resltant rows.

It is Sync scenario...

Can this be achived using XI by using Recever JDBC adatper by passing XML SQL statment..

Thanks

Subbu