Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to fetch the records based on particular format

BommiSep 13 2019 — edited Sep 16 2019

Hi Experts,

We need to fetch data from a custom table ABC based on a particular format that is available in field

Example, we have a filed Description in ABC. We need to fetch records only when Description field contains data in format p.nnnnn/nnn-nnn/nnn. Example the 'n' can be any numbers. Like: p.11111/111-111/111 or p.22222/222-222/222.

The total numbers after p. is 5 and after that / and then 3 numbers and then - and then again 3 number and then / and then 3 numbers.

The format is fixed.

Is there any way to fetch records based on this.

Thanks in Advance,

Bommi
This post has been answered by cormaco on Sep 13 2019
Jump to Answer

Comments

Post Details

Added on Sep 13 2019
#sql-developer
2 comments
258 views