SQL & PL/SQL

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!

Regular expression to rename a file with or without extension

UtsavJul 18 2017 — edited Aug 2 2017

Hi,

I have a requirement wherein, I've to rename filename column within the database with new one.

eg Sample.doc should be Sample_New.doc

or ReadMe --> ReadMe_New

Some sample list of filename that we have are with extensions and some are without extension

FileName

this.is.sample.pdf

this.is.just.a.doc.file.docx

IamTrickyPDF

Expected

this.is.sample_New.pdf

this.is.just.a.doc.file_New.docx

IamTrickyPDF_New

this.is.sample.pdfthis.is.just.a.doc.file.docxIamTrickyPDFEthis.is.sample.pdf

this.is.just.a.doc.file.docx

IamTrickyPDF

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 30 2017

Added on Jul 18 2017

9 comments

595 views