declare variable in oracle sql

PrashantUnity answered on January 18, 2023 Popularity 9/10 Helpfulness 3/10

answer declare variable in oracle sql

declare variable in oracle sql

Comment

SQL> var name varchar2(20)
SQL> exec :name := 'SALES'

PL/SQL procedure successfully completed.

SQL> select * from dept
  2  where dname = :name
  3  /

    DEPTNO DNAME          LOC
---------- -------------- -------------
        30 SALES          CHICAGO

SQL>

Popularity 9/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: declare oracle sql

Link to this answer
Share Copy Link

Contributed on Jan 18 2023

PrashantUnity

0 Answers Avg Quality 2/10

declare variable in oracle sql

Contents

More Related Answers

declare variable in oracle sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.