3a.1.92. DRG Attachments (OCI360_DRG_ATTACHS)

WHERE  substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad'
                                                             *

ERROR at line 4:
ORA-00904: "ID": invalid identifier
#: click on a column heading to sort on it

 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 DRG_ID                                                                                       VARCHAR2(1)
 LIFECYCLE_STATE                                                                              VARCHAR2(1)
 VCN_ID                                                                                       VARCHAR2(1)


SELECT t1.*
FROM   OCI360_DRG_ATTACHS t1
WHERE  substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad';


-1 rows selected.