Question:

table is defined as
But what i need is to help with my insert into sql comand where i can’t seem to find where is the issue
thank you for the sudgestions
Answer:
You have two issues:- The table name is
UKLIZECKA
and notPERSON
. ""
is for identifiers and''
is for string literals soto_date("10.10.2000")
is looking for a column identified by"10.10.2000"
rather than passing a string literal. You wantTO_DATE('10.10.2000', 'DD.MM.YYYY')
(with an explicit, rather than implicit, format model) or a date literalDATE '2000-10-10'
.- It is also best practice to specify the columns you are inserting into.
Like this:
If you have better answer, please add a comment about this, thank you!