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 : variable « SQL Plus « Oracle PL / SQL






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

    
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>

   
    
    
    
  








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 even be referenced by SQL queries
7.Undefine variable
8.User defined-variable in update set statement