--写个过程
create or replace procedure inserttable(p_username in varchar2) as
begin
insert into TB values('初始化接口1',p_user_name);
insert into TB values('初始化接口2',p_user_name);
insert into TB values('准备公用表',p_user_name);
insert into TB values('初始化细表',p_user_name);
insert into TB values('可以正常操作',p_user_name);
commit;
exception
when others then
rollback;
end ;
create or replace procedure inserttable(p_username in varchar2) as
begin
insert into TB values('初始化接口1',p_user_name);
insert into TB values('初始化接口2',p_user_name);
insert into TB values('准备公用表',p_user_name);
insert into TB values('初始化细表',p_user_name);
insert into TB values('可以正常操作',p_user_name);
commit;
exception
when others then
rollback;
end ;
CREATE TABLE TB(ActName VARCHAR2(20),Logname VARCHAR2(20));
INSERT ALL
INTO TB VALUES('初始化接口1','qufo')
INTO TB VALUES('初始化接口2','qufo')
INTO TB VALUES('准备公用表', 'qufo')
INTO TB VALUES('初始化细表', 'qufo')
INTO TB VALUES('可以正常操作','qufo')
SELECT 1
FROM DUAL;
SELECT * FROM TB;
DROP TABLE TB;如其他版本,可使用sqlldr实现.
insert into TB (Actname ,Loaname) select 信息,'qufo' from 来源表 where 条件;