-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
> This is definitely the behavior of MySQL, PostgreSQL, and Oracle, > and I'm pretty sure most others follow it as well. > Whoa. Be careful what you say about Oracle. > > Oracle does have default values for table columns, defined > by the DEFAULT clause in CREATE/ALTER TABLE. > > However, the _only_ way to get a column set to the default value > is to leave the column out of the INSERT statement altogether. > There is nothing you can put in a VALUES(..) list which > will do the trick, nor is there anything that can be bound to > a placeholder which will result in the default being set. You sure about that? You might want to check your docs, or update to a newer version of Oracle. If I recall correctly, this ability was added in 9i. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200604271837 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFEUUfrvJuQZxSWSsgRAt/YAKDvcFCDz41zVERWPb3OuI5Bmg3k1QCgyYmt Z6Id4DtXS519enpBJWN214U= =/wPB -----END PGP SIGNATURE-----
