APEX

Hello again,

I am here because I know I am missing something. I see I have a comma after every column name in the INSERT clause, and in the VALUES clause I put commas after the values for the corresponding columns.

Even if you don't tell me the exact reason, I'd appreciate any guidance to find out where my syntax is wrong.

Here is my code:

INSERT INTO appeals (appeal_id, crime_id, status, TO_CHAR(filing_date, 'MONTH DD YYYY')"Filing_Date",
TO_CHAR(hearing_date, 'MONTH DD YYYY')"Hearing_Date")
VALUES(APPEALS_ID_SEQ.NEXTVAL, :crime_id, '', :filing_date, :hearing_date);

Thanks!