asked on
oracle query
hi i want to get
the data only from second error i.e., using regexp or substr
ORA-28007:The pwd cannot be reused.
ORA-06502: PL/SQL:numeric or value error ORA-28007:The pwd cannot be reused.
thanks.
the data only from second error i.e., using regexp or substr
ORA-28007:The pwd cannot be reused.
ORA-06502: PL/SQL:numeric or value error ORA-28007:The pwd cannot be reused.
thanks.
Oracle Database
Last Comment
slightwv (䄆 Netminder)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Just in case you ever want just the second error no matter what:
This returned:
ORA-06502: PL/SQL:numeric or value error
with mydata as(
select 'ORA-28007:The pwd cannot be reused.
ORA-06502: PL/SQL:numeric or value error ORA-28007:The pwd cannot be reused.
' myerror from dual
)
select
regexp_substr(myerror,'(ORA-[0-9]{5}.+)(ORA-[0-9]{5})',1,1,null,1)
from mydata;
This returned:
ORA-06502: PL/SQL:numeric or value error
SUBSTR(COL1, INSTR(COL1, 'ORA-', 1, 2))