提示错误ORA00905:select * into A from B,缺少关键字 在PLSQL中写了一个语句:select * into A from B运行时提示:错误00905,缺少关键字请问是什么原因???谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * into A from BA需要定义。 那是MS-SQL的写法,ORACLE是create table b as select * from a --select * into A from B--*代表b表中的所有行的记录,即多条记录--如果你要获取统计记录(单条记录),可以如下写:SQL> set serveroutput on;SQL> declare 2 x number(2); 3 begin 4 select count(*) into x 5 from emp 6 where deptno=30; 7 8 dbms_output.put_line('The number of department 30 employees are :'||x); 9 end; 10 /The number of department 30 employees are :6PL/SQL procedure successfully completed-------------------如果你想获得多条记录,可以用游标返回多条记录:SQL> declare 2 cursor x is 3 select ename,deptno,job,sal 4 from emp; 5 begin 6 for v_emp in x 7 loop 8 dbms_output.put_line( 9 'ename= '||v_emp.ename|| 10 ', deptno= '||v_emp.deptno|| 11 ', job= '||v_emp.job|| 12 ', sal= '||v_emp.sal 13 ); 14 end loop; 15 end; 16 /ename= SMITH, deptno= 20, job= CLERK, sal= 800ename= ALLEN, deptno= 30, job= SALESMAN, sal= 1600ename= WARD, deptno= 30, job= SALESMAN, sal= 1250ename= JONES, deptno= 20, job= MANAGER, sal= 2975ename= MARTIN, deptno= 30, job= SALESMAN, sal= 1250ename= BLAKE, deptno= 30, job= MANAGER, sal= 2850ename= CLARK, deptno= 10, job= MANAGER, sal= 2450ename= SCOTT, deptno= 20, job= ANALYST, sal= 3100ename= KING, deptno= 10, job= PRESIDENT, sal= 5000ename= TURNER, deptno= 30, job= SALESMAN, sal= 1500ename= ADAMS, deptno= 20, job= CLERK, sal= 1100ename= JAMES, deptno= 30, job= CLERK, sal= 950ename= FORD, deptno= 20, job= ANALYST, sal= 3000ename= MILLER, deptno= 10, job= CLERK, sal= 1300 32位win7用哪个版本的oracle 怎么根据create语句修复表结构 jdbc连接数据库出错,请教高手 oracle索引小问题 求 oracle 10g 资料 请教将多个结果同时显示出来的 Sql 语句 请教高手:用JSP来管理数据库的导入导出,备份和恢复? 如何插入一列? 可怕呀!难道又要重新安装 写过oracle存储过程的来帮帮忙 大家好,问一个触发器的问题 这个sql语句如何写
A需要定义。
create table b as select * from a
--select * into A from B
--*代表b表中的所有行的记录,即多条记录--如果你要获取统计记录(单条记录),可以如下写:
SQL> set serveroutput on;
SQL> declare
2 x number(2);
3 begin
4 select count(*) into x
5 from emp
6 where deptno=30;
7
8 dbms_output.put_line('The number of department 30 employees are :'||x);
9 end;
10 /The number of department 30 employees are :6PL/SQL procedure successfully completed
-----------------
--如果你想获得多条记录,可以用游标返回多条记录:
SQL> declare
2 cursor x is
3 select ename,deptno,job,sal
4 from emp;
5 begin
6 for v_emp in x
7 loop
8 dbms_output.put_line(
9 'ename= '||v_emp.ename||
10 ', deptno= '||v_emp.deptno||
11 ', job= '||v_emp.job||
12 ', sal= '||v_emp.sal
13 );
14 end loop;
15 end;
16 /ename= SMITH, deptno= 20, job= CLERK, sal= 800
ename= ALLEN, deptno= 30, job= SALESMAN, sal= 1600
ename= WARD, deptno= 30, job= SALESMAN, sal= 1250
ename= JONES, deptno= 20, job= MANAGER, sal= 2975
ename= MARTIN, deptno= 30, job= SALESMAN, sal= 1250
ename= BLAKE, deptno= 30, job= MANAGER, sal= 2850
ename= CLARK, deptno= 10, job= MANAGER, sal= 2450
ename= SCOTT, deptno= 20, job= ANALYST, sal= 3100
ename= KING, deptno= 10, job= PRESIDENT, sal= 5000
ename= TURNER, deptno= 30, job= SALESMAN, sal= 1500
ename= ADAMS, deptno= 20, job= CLERK, sal= 1100
ename= JAMES, deptno= 30, job= CLERK, sal= 950
ename= FORD, deptno= 20, job= ANALYST, sal= 3000
ename= MILLER, deptno= 10, job= CLERK, sal= 1300