Re: mysql to oracle migration

Colm G. Connolly wrote:

> Hi all,
>
> I'm in the process of migrating to oracle (9.2.0.1.0) from Mysql and am
> having a few problems. Perhaps somebody might know how to solve them.
>
> 1. When I create my tables I try to create a column of boolean type but for
> some reason oracle doesn't like it. Should I just number(1) instead? (I've
> tried inhibitoryShunt boolean and inhibitoryShunt boolean default false)

Hmm...pretty sure there isn't a Boolean data type in SQL.

> 2. What are oracle equivalents of the MySql functions now() and
> last_insert_id()? I use them in the following contexts.

The equivalent of now() is sysdate. It doesn't need (or want) brackets, as it's considered a keyword rather than a function.

What does last_insert_id() do in mysql? Is it an OID thing?

Kris

> insert into configurationMap values (NULL, 'MoreInhibition', now(), null);
>
> insert into tableMap values (NULL, last_insert_id(), 'afferentSynapses',
> last_insert_id())
>
> Thanks in advance,
>
> Bye,
>
Received on Tue Feb 10 2004 - 07:00:44 CST