Native SQL to retrieve range

[Former Member]

Hi,

I have an requirement in which i need to retreive the data from oracle database(ODS) using native sql.

In the selection screen iam giving select option for lotid. Based on the lotid i need to retrieve the data from ODS.

If the user enters range for eg 1 to 5, how can i use that range in native sql query?

Regards,

Arun.

[Former Member]

Hi

Prepare your sql statement in ABAP , and execute it while activating the trace,

Then display trace and goto EXPLAIN SQL , here you will get the sql statement in native SQL ,now this statement will differ from the database you want to run the native sql on since, the statement you get will be native to the database your sap server is running on

But it should be similar .

Try it out.