create or replace package select_table
is
type tab_05 is record
(
itnum_1 varchar2(1),
itnum_2 varchar2(1),
itnum_3 varchar2(1),
itnum_4 varchar2(1),
itnum_5 varchar2(1)
);
type cur_5 is ref cursor return tab_05;
end select_table;
declare
cur system.select_table.cur_5;
begin
student_info1('王林','高数',cur);
dbms_output.put_line(); --()里的这个部分应该怎么写呢,我想输出过程结果.
end;----------------------------------------------------------------------------------------
create trigger cue_xs
after insert or update or delete on system.xs for each row
declare
infor char(10);
begin
if inserting then infor:='插入';
elsif updating then infor:='更新';
else infor:='删除';
end if;
insert into sql_info values(infor); --这里的sql_info是什么意思,整条语句是什么意思???
end cue_xs;
is
type tab_05 is record
(
itnum_1 varchar2(1),
itnum_2 varchar2(1),
itnum_3 varchar2(1),
itnum_4 varchar2(1),
itnum_5 varchar2(1)
);
type cur_5 is ref cursor return tab_05;
end select_table;
declare
cur system.select_table.cur_5;
begin
student_info1('王林','高数',cur);
dbms_output.put_line(); --()里的这个部分应该怎么写呢,我想输出过程结果.
end;----------------------------------------------------------------------------------------
create trigger cue_xs
after insert or update or delete on system.xs for each row
declare
infor char(10);
begin
if inserting then infor:='插入';
elsif updating then infor:='更新';
else infor:='删除';
end if;
insert into sql_info values(infor); --这里的sql_info是什么意思,整条语句是什么意思???
end cue_xs;
写出的输出结果,可以在student_info1这个过程中拼接出来,作为一个返回值。
sql_info 应该是一个表,纪录你的状态结果的!
insert into sql_info values(infor); --这里的sql_info是什么意思,整条语句是什么意思???
就是插入这个结果到这个表中!