@Dave thank u so much for your quick responses, indeed helped me a LOT
The query worked. I am mentioning the mistakes i was doing while writing them:
2nd statement is the correct working statement. Indicating by arrows and numbers
Full Query is here:
"insert into table_name(col1,col2,col3,col4,col5,create_date,created_by) values(00,0,'"+variable_1+"','"+system.Environment.UserName+ "','New',TO_DATE('23-04-49 20:18:07','DD-MM-YY HH24:MI:SS'),'" +system.Environment.MachineName+"')"
This error : ORA-00933: SQL command not properly ended
was resolved with proper spacing . Pls refer this click here --> Spacing provided at 1, 3(as shown in screenshot)
This error : ORA-01756: Quoted String Not Properly Terminated
was resolved by changing the quote style for --New-- as shown by 2 in screenshot.
Pls refer this click here
Thanks again @Dave