ORA-00917: missing comma error

Below is my query in ORACLE, which receives error ORA-00917: missing comma .

 INSERT INTO user_account_statement( statement_id, session_key, login_id, user_id, account_number, from_date, to_date, ipaddress, create_date_time ) VALUES(1070, 'fe79e0345986b5a439c26f731234868b53f877366f529', '2335', '204254', '108142', to_date('2014-08-18','yyyy-mm-dd'), to_date('2014-08-23','yyyy-mm-dd'), '106.79.126.249', to_date('2014-08-23 16:45:06','yyyy-mm-dd hh24:mi:ss'); 

I do not know where the comma is now required.

+5
source share
1 answer

It seems like the end is missing ) :

 INSERT INTO user_account_statement(statement_id,session_key,login_id,user_id, account_number,from_date,to_date,ipaddress,create_date_time) VALUES(1070,'fe79e0345986b5a439c26f731234868b53f877366f529','2335','204254','108142', to_date('2014-08-18','yyyy-mm-dd'),to_date('2014-08-23','yyyy-mm-dd'), '106.79.126.249',to_date('2014-08-23 16:45:06','yyyy-mm-dd hh24:mi:ss')); 
+9
source

Source: https://habr.com/ru/post/1201551/


All Articles