Thanks Rick
On 11/21/05, Rick Hillegas <[EMAIL PROTECTED]> wrote:
Hi Francois,
I think what is puzzling you is the use of a single INSERT statement to
poke two rows into the table. Each of the parenthisized lists after the
VALUES keyword is actually a separate tuple. Putting each tuple on its
own line might clarify this.
Thanks,
-Rick
Francois Orsini wrote:
> Ok thanks for the nullable clarification .
>
> I would not necessarily associate ANSI BOOLEAN datatype to
> java.lang.Boolean one (different domains), but for the sake of this
> clarification, it does work.
>
> The statement I mentioned is:
>
>INSERT INTO SAMPLE( boolCol ) VALUES ( true ), ( false );
>
>There is only 1 column in the table - the VALUES clause shows 2 values...It may be that am not up-to-date on the latest SQL syntax ;)
>
>Thanks,
>
>
>--francois
>
>
>
>
