Sven K�hler wrote:
>
> > Notice that if you specify a value for the serial field in
> your insert
> > statement, no serial is generated but the specified value
> is inserted. In
> > this case, the above statement returns an error
> (-2029:CURRVAL is not yet
> > defined in this session)
>
> what would be returned here?
> (id is the serial-column)
>
> insert into my_table(text) values ('test1')
> insert into my_table(id, text) values (2, 'test1')
> select my_table.currval from sysdba.dual
>
> i think 1 will be returned, instead of the error.
correct (assuming that the first insert written here
is the first insert into that table)
Only if the first insert was not done, the error
mentioned above would be returned.
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
