Bind variables can even be referenced by SQL queries : variable « SQL Plus « Oracle PL / SQL

  1. Oracle PL / SQL
  2. SQL Plus
  3. variable




Bind variables can even be referenced by SQL queries

    

SQL>
SQL> SET ECHO ON
SQL> 
SQL> VARIABLE  s_table_name  varchar2(30)
SQL>
SQL> 
SQL> BEGIN
  2    :s_table_name := 'emp';
  3  END;
  4  /

PL/SQL procedure successfully completed.

SQL>
SQL> 
SQL> SELECT index_name
  2    FROM user_indexes
  3   WHERE table_name = :s_table_name;

no rows selected

SQL>
SQL> SET SERVEROUTPUT ON
SQL> BEGIN
  2    DBMS_OUTPUT.PUT_LINE(:s_table_name);
  3  END;
  4  /
emp

PL/SQL procedure successfully completed.

SQL>










Related examples in the same category

1.refcursor varible
2.Save returning value from a function to a variable
3.Define variable and print its value out
4.Define variable and set value
5.Define variable and use it in sql statement
6.Bind variables can be declared in your SQL*Plus script,Preface a bind variable with a colon to reference it in a PL/SQL block
7.Undefine variable
8.User defined-variable in update set statement