Re: Converting from Sybase SQL Anywhere to Oracle

In Oracle use Sequence :

create table mytable(mycol integer);

create sequence myseq .....

create trigger mytrigger before insert into mytable for each row is begin
  select myseq.nextval into :new.mycol from dual; end;

Jan Erik Hermansen wrote:

> I'm trying to move a database created in Sybase SQL Anywhere to Oracle
> 7.3.3.0.0 and have come across the following problem.
>
> In SQL Anywhere you can do the following:
> create table mytable ( mycol integer DEFAULT AUTOINCREMENT);
>
> This syntax doesn't work in Oracle. Is there another way to do this?
>
> Jan Erik
Received on Sat Jul 10 1999 - 11:44:34 CDT