sql查询-使用替换变量查询

使用替代变量查找员工ID
select employee_id,last_name,salary,department_id from employees
where employee_id = & employee_id;


查询结果

字符型加‘’
select employee_id,first_name,last_name,salary,department_id from employees
where first_name = ‘&ename’
order by 2;

输入first_name

查询时加’’
select employee_id,first_name,last_name,salary,department_id from employees
where first_name = &ename
order by 2;



自定义变量列名，和列值
select employee_id,first_name,last_name,job_id,&lieming from employees
where &tiaojian;

指定列的名



使用define命令创建变量并为其赋值
define employee_num = 200;

select employee_id,first_name,last_name,salary,department_id from employees
where employee_id = &employee_num;

使用undefing命令删除变量
undefine employee_num

更改提示消息如下
accept bumen PROMPT ‘shu ru bu men id’
select employee_id,first_name,last_name,department_id from employees
where department_id=&bumen;


查看查询结果

使用双&
select employee_id,first_name,last_name, job_id,&&zidingyi
from employees;


查看查询结果

UNDEFINE zidingyi 取消刚才定义的salary

增加排序列order by
select employee_id,first_name,last_name, job_id,&&zidingyi
from employees order by &zidingyi;

使用verify命令切换替换变量的显示
一块执行
set verify on
select employee_id,last_name,salary from employees
where employee_id = &bumen;