merge info用法,简单总计就是“有则更新,无则插入”
create table
t_B_info_student
(
s_no varchar2(10),
s_name varchar2(100),
s_sex varchar2(10),
create_by varchar2(10),
create_date date
);
2、添加学生信息
begin
for i in 1 .. 10 loop
insert into
t_B_info_student
(s_no, s_name, s_sex, create_by, create_date)
values
('N' || lpad(i, 9, 0), '姓名' || i,decode(mod(i,2),0,'男','女') , 'admin', sysdate);
end loop;
end
;
3、查询学生信息
select * from t_B_info_student ;
S_NO | S_NAME | S_SEX | CREATE_BY | CREATE_DATE | |
1 | N000000001 | 姓名1 | 女 | admin | 2016/11/11 10:17:53 |
2 | N000000002 | 姓名2 | 男 | admin | 2016/11/11 10:17:53 |
3 | N000000003 | 姓名3 | 女 | admin | 2016/11/11 10:17:53 |
4 | N000000004 | 姓名4 | 男 | admin | 2016/11/11 10:17:53 |
5 | N000000005 | 姓名5 | 女 | admin | 2016/11/11 10:17:53 |
6 | N000000006 | 姓名6 | 男 | admin | 2016/11/11 10:17:53 |
7 | N000000007 | 姓名7 | 女 | admin | 2016/11/11 10:17:53 |
8 | N000000008 | 姓名8 | 男 | admin | 2016/11/11 10:17:53 |