Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> ORACLE BUG FROM 8.1.6 ON! HELP!
Hi, everybody:
Try this on win with oracle 8.1.x
CREATE SEQUENCE ID_CEN
INCREMENT BY 1
MAXVALUE 9999
MINVALUE 1
;
CREATE TABLE CENTRO (
ID_CEN NUMBER(4) NOT NULL, DESCRIZIONE VARCHAR2(30) NULL, PRIMARY KEY (ID_CEN)
select id_cen.nextval from dual union select id_cen from centro;
It works on 8.1.5 and lower and gives an error on 8.1.6 and upper? Any hints or workaround? Received on Sat Sep 28 2002 - 05:39:37 CDT
![]() |
![]() |