declare
v_emp varchar2(1000);
beginselect'员工Gee的工作是:'|| b.job_title ||',他的薪水是:'|| a.salary
into v_emp
from hr.employees a, hr.jobs b
where a.job_id = b.job_id
and last_name ='Gee';
dbms_output.put_line(v_emp);
end;
Oracle数据库中查询重复数据: select * from employee group by emp_name having count (*)>1; Oracle 查询可以删除的重复数据 select t1.* from employee t1 where (t1.emp_name) in (SELECT t2.emp_name ...