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!

How do I assign a variable?

ToolTimeTaborMar 12 2020 — edited Mar 18 2020

I want to develop a query that filters by a variable.

I have found multiple examples that say I need to use DECLARE block. So, I tried what works in a PL SQL package. It does not work in SQL Developer.

So, using SQL Developer, how do I create a variable, set the value and then use it like illustrated below...

pastedImage_0.png

Comments
Post Details
Added on Mar 12 2020
23 comments
23,867 views