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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Mar 12 2020
23 comments
18,720 views