Create or replace procedure p_showinfo
As
V_sql varchar2(300);
V_name emp.姓名%type;
V_salary emp.工资%type;
V_score emp.成绩%type;
V_rank emp.名次%type;
V_position emp.职位%type;
Declare
Begin
Course cour as
Select distinct 职位 from emp;
For v_position in cour loop
Select 姓名 into v_name,工资 into v_salary,成绩 into v_score,名次 into v_rank from emp where 职位=v_position and rownum<4;
v_sql :=’insert into good values(v_name,v_salary,v_score,v_rank)’;
execute immediate v_sql;
End loop;
End;
我没有按照oracle中emp表的字段写,我对oracle一点都不熟,对sql也不熟悉