How to add parameters to SQL

sivadoss87 · ‎02-24-2016

Hi ,

I am connecting to Oracle database and giving my SQL in the SQL statement Block. I want to add parameters to my query.

How to add the parameters to the query , the main objective is to reduce the data loading time . So please someone help me to achieve this.

Regards,

P.Kalidoss

BenWei · ‎10-03-2016

Don't know if you had this issue resolved. If yes, could you please share your solution. I am having this issue too.

Thanks

ImkeF · ‎10-03-2016

As far as I'm aware this sould work for Oracle as well:

(although I've never tested it..)

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Helpful resources