SELECT REGEXP_SUBSTR (filename, '[[:alpha:]]+') filename, data

Table1- have two column
filename data
AFGDFD-20112011 hi how r u
bsdasd-23042011 name shoud be in bold
Now i want output like
filename data
AFGDFD hi how r u
bsdasd name shoud be in bold

Kindly answer this

Question Posted / suman rana

2 Answers
5227 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / suman rana

SELECT REGEXP_SUBSTR (filename, '[[:alpha:]]+') filename, data
FROM (SELECT 'AFGDFD-20112011' filename, 'hi how r u' data
FROM DUAL
UNION
SELECT 'bsdasd-23042011', 'name shoud be in bold' FROM DUAL)

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a server parameter file in oracle?

1036

Describe the types of sub query?

982

What exactly do quotation marks around the table name do?

953

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1831

What is the difference between sharding and replication?

1021

What is the use of aggregate functions in oracle?

1015

How does one get the view definition of fixed views/tables?

1004

How to turn on or off recycle bin for the session?

1089

Define oracle database

1029

What is the difference between substr and instr?

1025

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2236

Explain about integrity constraint?

1111

what is Single Byte Overhead...?

2540

How translate command is different from replace?

1063

What do you mean by cdb and pdb in oracle 12c?

1045