SQL> set serveroutput on
SQL> declare
2 v_num1 number :=345;
3 v_num2 number:=390;
4 v_char1 varchar2(50):='abcdmrst';
5 v_char2 varchar2(22):='aljjdsa';
6 outchar varchar2(50);
7 begin
8 insert into test2 values(v_num1,v_char1);
9 insert into test2 values(v_num2,v_char2);
10 select VCOLUMN into outchar
11 from test2
12 where ncolumn=v_num1;
13 dbms_output.put_line(outchar);
14 end;
15 /declare
v_num1 number :=345;
v_num2 number:=390;
v_char1 varchar2(50):='abcdmrst';
v_char2 varchar2(22):='aljjdsa';
outchar varchar2(50);
begin
insert into test2 values(v_num1,v_char1);
insert into test2 values(v_num2,v_char2);
select VCOLUMN into outchar
from test2
where ncolumn=v_num1;
dbms_output.put_line(outchar);
end;ORA-01422: 实际返回的行数超出请求的行数
ORA-06512: 在line 10SQL>
SQL> declare
2 v_num1 number :=345;
3 v_num2 number:=390;
4 v_char1 varchar2(50):='abcdmrst';
5 v_char2 varchar2(22):='aljjdsa';
6 outchar varchar2(50);
7 begin
8 insert into test2 values(v_num1,v_char1);
9 insert into test2 values(v_num2,v_char2);
10 select VCOLUMN into outchar
11 from test2
12 where ncolumn=v_num1;
13 dbms_output.put_line(outchar);
14 end;
15 /declare
v_num1 number :=345;
v_num2 number:=390;
v_char1 varchar2(50):='abcdmrst';
v_char2 varchar2(22):='aljjdsa';
outchar varchar2(50);
begin
insert into test2 values(v_num1,v_char1);
insert into test2 values(v_num2,v_char2);
select VCOLUMN into outchar
from test2
where ncolumn=v_num1;
dbms_output.put_line(outchar);
end;ORA-01422: 实际返回的行数超出请求的行数
ORA-06512: 在line 10SQL>
解决方案 »
- windows系统被我ghost恢复了,但是在E盘的oracle目录。。。
- 请高手指导如何优化该sql,用oracle plsql编写
- oracle计划任务的问题
- 一个sql语句问题
- linux 下 oracle安装运行后登陆问题
- 包是否可以命名成这种形式:UTILITY.FILE.PA_XXXX_PACKAGE?应该如何做?
- oracle 基础
- 江湖救急,十万火急-100分急问客户端和服务器端的字符集一致时发生的字符集乱码问题
- 关于ORACLE的基础问题
- SQL语句的书写问题!急急急
- 我的第一个存储过程,忘高手指点迷津,叩谢!
- oracle触发器中:new."列名" 如何将列名改为一个动态变量 ,问题解决马上结贴
from test2
where ncolumn=v_num1;
返回的行数超过一行,在INTO后是不允许的
select VCOLUMN into outchar
from test2
where ncolumn=v_num1
and rownum < 2;
11 from test2
12 where ncolumn=v_num1
系统提示这个语句返回的多汉行数据,
可以单独执行那个查询看看
或者加上rownum=1的限制条件