Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

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>