我用oracle9.0DB
下面的语句有编译错误
...没有左括号
为什么呢?
declare
v_record table1%ROWTYPE;
begin
...
insert into table1values v_record;
end;
下面的语句有编译错误
...没有左括号
为什么呢?
declare
v_record table1%ROWTYPE;
begin
...
insert into table1values v_record;
end;
v_record table1%ROWTYPE;
begin
...
insert into table1values v_record;
end;
table1 values
少个空格。
declare
v_record table1%ROWTYPE;
begin
...
insert into table1 values v_record;
end;
v_record ta%ROWTYPE;
begin
insert into ta values v_record;
end;
可以像2楼说的那样拆成几个变量来插入
或者用insert into tablename select ... from ..