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
