It's a question from MAPPER

For now, the query mapper literally only functions to create a query, so the question, Mybatis, and Spring are not related.

So let's just think about the query.

CREATE TABLE MY_TABLE(
    COL1 NUMBER,
    COL2 NUMBER,
    COL3 NUMBER
);

INSERT INTO MY_TABLE(
    COL1, COL2
) VALUES (
    123, 456
);

Even if there are three defined columns, INSERT can only specify some columns. However, since null is automatically inserted in the omitted column, there is a condition that the column should be allowed null.

If you look at the table definition attached by the author of the brute, all columns (assuming that that shot is all) do not allow NN, or null. So you can't omit any columns in this situation.