select t.teacherno,teachersex,teachername,teacherdesc,departname into teacherbackinfo
from teacherinfo t,
(select teacherno,count(*) cc from teachercourseinfo group by teacherno
order by cc ) b
where t.teacherno=b.teacherno and rownum<=10select t.teacherno,teachersex,teachername,teacherdesc,departname into teacherbackinfo from teacherin
*
第 1 行出现错误:
ORA-00905: 缺失关键字
from teacherinfo t,
(select teacherno,count(*) cc from teachercourseinfo group by teacherno
order by cc ) b
where t.teacherno=b.teacherno and rownum<=10select t.teacherno,teachersex,teachername,teacherdesc,departname into teacherbackinfo from teacherin
*
第 1 行出现错误:
ORA-00905: 缺失关键字
这个 teacherbackinfo 是表?
是不是要将指定的数据插入表中?
不能这么写是要将count前10的记录插入吗
select t.teacherno,teachersex,teachername,teacherdesc,departname
from teacherinfo t,
(select teacherno,row_number()over(order by count(*)) cc from teachercourseinfo group by teacherno ) b
where t.teacherno=b.teacherno and rn<=10
在sql/plus或者PL/SQL执行select into table_name from ,会报"ORA-00905:缺失关键字"错误,原因是PL/Sql与T-SQL的区别。
T-SQL中该句正常,但PL/SQL中解释是:
select..into is part of PL/SQL language which means you have to use it inside a PL/SQL block. You can not use it in a SQL statement outside of PL/SQL.
即不能单独作为一条sql语句执行,一般在PL/SQL程序块(block)中使用。如果想在PL/SQL中实现该功能,可使用Create table newTable as select * from ...:
如: create table NewTable as select * from ATable;
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716