orcl@ HR>VARIABLE X VARCHAR2(25)
orcl@ HR>VARIABLE X
variable x
datatype VARCHAR2(25)
orcl@ HR>
orcl@ HR>BEGIN
2 :X := 'Abel';
3 END;
4 /
PL/SQL procedure successfully completed.
orcl@ HR>SELECT EMPLOYEE_ID,FIRST_NAME,SALARY
2 FROM EMPLOYEES
3 WHERE LAST_NAME = :X;
EMPLOYEE_ID,FIRST_NAME , SALARY
-----------,--------------------,----------
174,Ellen , 11000