SQL PLUS Session Environment Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. SQL PLUS Session Environment
  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>