SQL Plus Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. SQL Plus
  4. Define variable and set value
SQL>
SQL> SET ECHO ON
SQL>
SQL> VARIABLE ename VARCHAR2(30)
SQL> EXECUTE :ename := 'Mike';
PL/SQL procedure successfully completed.
SQL> SELECT :ename FROM dual;
Mike
1 row selected.
SQL>
SQL>