Re: null-columns in select-statement

Kasper, Kay wrote: Hi, i try to use a select-statement like this "(select col1, col2, null, col4 from tablex)" in an insert-statement. As a result i get an SQLException with state 42X01, code 3 that says syntax error at null. Even if i use a very simple statement like (i created a table

null-columns in select-statement

Hi, i try to use a select-statement like this "(select col1, col2, null, col4 from tablex)" in an insert-statement. As a result i get an SQLException with state 42X01, code 3 that says syntax error at null. Even if i use a very simple statement like (i created a table like DUAL in Oracle)