Shane Ambler wrote:
> Raymond O'Donnell wrote:
>
...
>> INSERT INTO table (fld_y, fld_z) VALUES ('y', 'z');
>
> Another way is INSERT INTO table VALUES (NULL,'y','z')
of course you meant:
INSERT INTO table VALUES (DEFAULT,'y','z')
since Null would be wrongly insert NULL value instead
of using the sequence value.
Regards
Tino