Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 8.1.5 - Dual gone schizoid

8.1.5 - Dual gone schizoid

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 30 Dec 1999 14:08:36 -0000
Message-ID: <946563069.23198.0.nnrp-14.9e984b29@news.demon.co.uk>

Has anyone encountered this before ?
Oracle 8.1.5.0 on NT sp3:

sqlplus sys/sys
select count(*) from sys.dual;

 COUNT(*)


       2

select sysdate from sys.dual;

 SYSDATE



30-DEC-99 declare

    d date;
begin

    select sysdate into d from sys.dual; end;
.
/

ORA-01422: exact fetch returns more than requested number of rows

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Received on Thu Dec 30 1999 - 08:08:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US