Re: A couple of newbie questions ...

[Tino Wildenhain <tino@xxxxxxxxxxxxx>]

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

<<attachment: smime.p7s>>