치환변수 (외부 입력)

 

--치환변수, 외부입력 받기------------------------------

 

--치환변수------------------------------

select employee_id, salary, department_id

from employees

where employee_id = &employee_num;

 

--치환 변수 "문자,날짜"

select last_name, department_id, salary*12

from employees

where job_id = upper('&job_title');  --''로 묶어줘야함

 

--열 이름, 표현식 및 텍스트 지정

select employee_id, last_name, job_id, &column_name

from employees

where &condition

order by &order_column;

 

--&&치환 변수 사용

select employee_id, last_name, job_id, &&column_name

from employees

order by &column_name;

 

show verify

 

set verify on

set verify off