dkfr.net
当前位置:首页 >> orAClE一直提示sElECt后缺少into >>

orAClE一直提示sElECt后缺少into

PL/SQL语句块里,单独的select语句必须和into语句成对出现。 语法如此 返回结果集 需要用到游标。单独的过程不能是一个查询语句。 即使这样 也报错的 begin select * from tablea ; end; 这样: as cursor c_cur is select * from tablea; begin ...

select语句的语法是没有into的。 sql:select * from tablename where 条件。 解释:以上语句就是select的用法,是没有into关键字的。 扩展一:insert 语句是有into的。 sql: insert intotablename(id) values(12); 扩展二:存储过程中有into语...

这个看一下对你是否有帮助埃查询多行内容用游标啊 declare cursor mycur is select * from checkTmp order by expressID; myrecord checkTmp%ROWTYPE; BEGIN OPEN mycur; FETCH mycur INTO myrecord; WHILE mycur%FOUND LOOP DBMS_OUTPUT.PUT_LI...

select出来的结果要放到变量中去,select ... into .... from ... where ....

直接建相同的表create table students_backup as select * from students; 直接建相同的表结构create table students_backup as select * from students where 1=2; 如果建好了表insert into students_backup select * from students

CREATE OR REPLACE PROCEDURE PROADMININFO (ADMINNAME in varchar2,ADMINPWD in varchar2)ISBEGINselect * from userinfo where loginid=ADMINNAME and password=ADMINPWD; END PROADMININFO; PROCEDURE ZXDRB.PROADMININFO 编译错误 错误:PLS...

报缺少关键字错误,说明sql语法不符合规范导致的: 可以参考下以下语法sql: select tablecolume2 , sum (tablecolume1 ), count (tablecolume1 3) from tablename where 条件1 or 条件2 and 条件3 order by tablecolume1 group by tablecolume2...

--应该这样改吧 create procedure p_findUser (@v_id number) as select id,name,pwd,email,tel,birthday,grade from users where id= @v_id;;

在编写存储过程或是触发器时,必须把查询出的结果存入于结果类型相同的变量中,上面的sql应改为 select to_char(count(*))as KNUM into 变量名称 from tdkdy t where to_char(time,'yyyy')='year' and rownum = 1 group by to_char(time,'mm') ;

你把你写的发上来看看 你这么说谁知道哪里错了

网站首页 | 网站地图
All rights reserved Powered by www.dkfr.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com