把字段值写全了,给个参考:
insert into Instructor
(Instructor_ID,First_name)
select Instructor_ID,name from Inactor;
insert into Instructor
(Instructor_ID,First_name)
select Instructor_ID,name from Inactor;
2 (a varchar2(20),
3 b number);表已创建。
SQL> insert into t1 values('dkfjk',20)
2 /已创建 1 行。
SQL> insert into t1 values('bbbbb',30);已创建 1 行。SQL> insert into t1(a,b) select a ,b from t1;已创建2行。