SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to pass a value into a SQL Query?

514497Jul 12 2007 — edited Jul 17 2007

Hi There,

I want to know if there is a possibility to pass a dynamic value in a sql query. For example I have a currency rate value (ex: rate = 1.319, 2.23 etc) which user wants to input when running the query (The rate is not taken from the system, so I cannot compare to any table column and pass it as a parameter).

And this rate has to be used in my query to do some calculation. Is this possible? The value :p_currency_rate doesn't work

Any ideas please?

Thank you,
Prathibha

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2007

Added on Jul 12 2007

10 comments

636 views