Re: Converting from Sybase SQL Anywhere to Oracle

From: Denny Koovakattu <denny_vk_at_my-deja.com>
Date: Fri, 09 Jul 1999 21:25:37 GMT
Message-ID: <7m5pc4$lhl$1@nnrp1.deja.com>

Hi,

I guess you may have to use a combination of sequences and triggers to generate the sequence numbers.

Regards,
Denny

In article <Ujkh3.150$Vg3.526_at_news1.online.no>, "Jan Erik Hermansen" <jeh_at_susoft.no> 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
>
>

--
Denny Koovakattu
denny_at_vitalsol.com
http://vitalsol.com/

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 09 1999 - 16:25:37 CDT