I have a string(or two records) of the type:
a) C:\Users\user1\Pictures\1.JPG
b) C:\Users\user1\Pictures\file_example_TIFF_1MB.tiff
When I use this:
select dt, seq, message,REGEXP_SUBSTR(message, '[0-9]+(.JPG|.TIFF|.tiff)+')
from log_output_table where seq in (23438852,23438853);
When I use this:
select dt, seq, message,REGEXP_SUBSTR(message, '[[:alnum:]]+(.JPG|.TIFF|.tiff)+')
from log_output_table where seq in (23438852,23438853);
1.JPG
example_TIFF
Can anyone help me out? Thanks in advance.
] 
Blog
Search
Help
Members
Register
Login
Home
