Home > OS >  ORA-01722: invalid number 01722. 00000 - "invalid number" *Cause: The specified number was
ORA-01722: invalid number 01722. 00000 - "invalid number" *Cause: The specified number was

Time:12-10

I am new to Oracle SQL Developer, and today while running this

select r.id, r.date,  it.group, it.comment, it.item, it.remark, r.summary,
substr (it.remark, instr(it.remark,'ABC') 8,7 )  as label1,
cast(substr (it.remark, instr(it.remark,'-') 1,3 ) as integer) as label2
from it_table it 

inner join sp_table sp on sp.id = substr (it.remark, instr(it.remark,'ABC') 8,7 ) and sp.label_id = cast(substr (it.remark, instr(it.remark,'-') 1,3 ) as integer) 
inner join sq_table sq on sq.id = sp.id
where it.date > '01-jan-2020' and it.remark like '           
  • Related