错误信息呢!!
我的没有错啊!!
SQL> select * from t1; ID NAME SEX
---------- ---------- ----------
1 a a
2 b b
3 c cSQL> select * from t2; ID NAME JOB HIREDATE DEF_HIREDA SID
---------- --------------- ---------- ---------- ---------- ----------
1 a 10-1月 -05
2 b 10-1月 -05
3 c 10-1月 -05
4 d 4.69SQL> insert t1 select ID,'d','d' from t2 where ID=4;
insert t1 select ID,'d','d' from t2 where ID=4
*
ERROR 位于第 1 行:
ORA-00925: 缺失 INTO 关键字
SQL> INSERT INTO T1 SELECT ID,'d','d' FROM T2 WHERE ID=4;已创建 1 行。SQL> SELECT * FROM T1; ID NAME SEX
---------- ---------- ----------
1 a a
2 b b
3 c c
4 d d
我的没有错啊!!
SQL> select * from t1; ID NAME SEX
---------- ---------- ----------
1 a a
2 b b
3 c cSQL> select * from t2; ID NAME JOB HIREDATE DEF_HIREDA SID
---------- --------------- ---------- ---------- ---------- ----------
1 a 10-1月 -05
2 b 10-1月 -05
3 c 10-1月 -05
4 d 4.69SQL> insert t1 select ID,'d','d' from t2 where ID=4;
insert t1 select ID,'d','d' from t2 where ID=4
*
ERROR 位于第 1 行:
ORA-00925: 缺失 INTO 关键字
SQL> INSERT INTO T1 SELECT ID,'d','d' FROM T2 WHERE ID=4;已创建 1 行。SQL> SELECT * FROM T1; ID NAME SEX
---------- ---------- ----------
1 a a
2 b b
3 c c
4 d d
update a_bak set a_bak.column2=(select a.column2 from a where a.column1=a_bak.column1);
ORA-00997:illegal use of LONG datatype
:(
为什么LONG数据类型会抱:非法使用 LONG 数据类型
c1 varchar2(2);
c2 long;
begin
open cur;
loop
fetch cur into c1,c2;
exit when cur%notfound;
insert into a_bak select c1,c2 from dual;
end loop;
end;