17,377
社区成员
发帖
与我相关
我的任务
分享
create table
tableA
(id number(8),
title varchar2(100),
createdate date default sysdate
);
create sequence
idseq
start with 1
increment by 1;
create or replace procedure tableA_additem
(
title in tableA.title%type
)
is
begin
insert into tableA(id,title) values(idseq.nextval,title);
end tableA_additem