建表语句
员工信息表 tb_info
CREATE TABLE scott.tb_info(
dept char(2) , --部门
staff_name varchar2(10) , --工号
sex char(1) ,
sal number(18,2)
);
insert into scott.tb_info(dept,staff_name,sex,sal) values('01','张三','0',5000);
insert into scott.tb_info(dept,staff_name,sex,sal) values('01','李三','0',4000);
insert into scott.tb_info(dept,staff_name,sex,sal) values('01','李四','1',5500);
insert into scott.tb_info(dept,staff_name,sex,sal) values('02','王五','0',4500);
insert into scott.tb_info(dept,staff_name,sex,sal) values('02','赵六','1',6000);
insert into scott.tb_info(dept,staff_name,sex,sal) values('02','赵七','1',3000);
题目
1. 查询所有男员工的全部信息
代码