Skip to Main Content

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!

Change Variable value

AmiroshSep 16 2019 — edited Sep 16 2019

Hello,

Hope this is the right place to raise the next question,

I want to create a situation where I have a variable that I will replace every time and a query that I have will change depending on the variable.

I realized that there was an option with the DECLARE command but I couldn't implement it well.

The idea is to create a variable that each time I change the values the values will run accordingly.

At first I thought of creating another table with a single value that I would change but this solution is not good for me.

I would love if you could help.

Thanks

Comments
Post Details
Added on Sep 16 2019
3 comments
1,190 views