I have SYSTEM_SQL_CHECK table in which i have saved sql in CHECK_SQL column. This column is Varchar data type. Now i want to update particular sql.I have written below update sql query but it gives an error
SQL Error: ORA-00933: SQL command not properly ended. I also tried to query with double quote but then it gives an error as
SQL Error: ORA-00972: identifier is too long.
Update RATOR_MONITORING_CONFIGURATION.SYSTEM_SQL_CHECK SET CHECK_SQL = 'select count(*) as CNT from O2_SDR_Header where id = (select max(id) from O2_SDR_Header where id > 2012000000000000 and sp_id = 'SP602') And sp_id = 'SP602' and FILE_CREATED_DATE > (SYSTIMESTAMP - INTERVAL '2' HOUR)' WHERE SYSTEM_SQL_CHECK_ID = 604;