After running this query I am getting Result properly:
SELECT REGEXP_REPLACE(REGEXP_SUBSTR(TBLUSERACTIVITIES.ACTION, 'Event [0-9]+'),'Event ') as EventId1, REGEXP_REPLACE(REGEXP_SUBSTR(TBLUSERACTIVITIES.ACTION, 'Event [0-9]+',1,2,'i'),'Event ') as EventId2 FROM EAITEMP.TBLUSERACTIVITIES TBLUSERACTIVITIES
Out Put :
EventID1 | EventID2
123 | 235
But While running this query i am getting error as :
Error report:
SQL Error: ORA-00936: missing expression
00936. 00000 - "missing expression"
*Cause:
*Action:
insert into EAITEMP.TBLUSERACTIVITIES(EventID1, EventID2) values(SELECT REGEXP_REPLACE(REGEXP_SUBSTR(TBLUSERACTIVITIES.ACTION, 'Event [0-9]+'),'Event ') as EventId1, REGEXP_REPLACE(REGEXP_SUBSTR(TBLUSERACTIVITIES.ACTION, 'Event [0-9]+',1,2,'i'),'Event ') as EventId2 FROM EAITEMP.TBLUSERACTIVITIES TBLUSERACTIVITIES);
Thanks in Advance