VARIABLE IN THE SQLPLUS 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 더보기 이전 1 ··· 258 259 260 261 262 263 264 ··· 595 다음