Following db query not working. | dbquery wmsewprd select REC_TYPE, CODE_TYPE, CODE_DESC, SHORT_DESC, USER_ID, To_Char(mod_date_time,'dd/mm/yyyy hh:mi:ss AM') AS MOD_DATE_TIME from SYS_CODE_TYPE where rec_type = 'C' and code_type = 'AWO' and (sysdate - mod_date_time)*24*60 < 60" Getting following error. command="dbquery", A database error occurred: ORA-00942: table or view does not exist But the table SYS_CODE_TYPE does exist. When we run the following query it is returning events. dbquery wmsewprd "select REC_TYPE, CODE_TYPE, CODE_DESC, SHORT_DESC, USER_ID from SYS_CODE_TYPE" What could be the problem
... View more