cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: General DB question
Date Fri, 16 Mar 2001 17:33:22 GMT
On Tue, 13 Mar 2001, Berin Loritsch wrote:

> I want to add one more mode to the keys, so that we can
> automatically specify a Sequence object.  In Oracle, the
> syntax works like this:
>
> INSERT INTO myTable VALUES (
>     MySequence.NEXTVAL,
>     "new thing"
> );
>
> Or if you have multiple tables that work together, it
> would be like this:
>
> INSERT INTO myTable VALUES (
>     MySequence.NEXTVAL,
>     "new thing"
> );
>
> INSERT INTO myOtherTable VALUES (
>     MySequence.CURRVAL,
>     "associated thing"
> );
>
> My question is, "Is this Oracle specific, or generic
> enough to fit in the DatabaseAddAction object?".

every vendor has their own sequence syntax, unfortunately.

- donald


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message