SQLPLUS에서의 치환변수

ㆍ값의임시적저장을위해세가지치환변수형태제공
   - & : 값의1회사용을위한치환변수사용시
   - && : 후속사용을위한치환변수사용시
   - DEFINE : 치환변수의사전선언시사용

ㆍSELECT문의모든절에사용가능

 

 (1) &
 SELECT last_name, salary FROM employeesWHERE salary = &sal;
 SELECT last_name, salary FROM employeesWHERE last_name = ‘&name’;
 SELECT last_name, salary, &colFROM employeesWHERE &conditionORDER BY ℴ
 
 (2) &&
 SELECT last_name, salary, &&colFROM employeesORDER BY &col;
  
 (3) DEFINEDEFINE 
 v_empid= 300
 SELECT last_name, salaryFROM employeesWHERE employee_id = &v_empid;