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
5146 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 the data type of dual table?

921

Who developed oracle & when?

945

What is hash cluster in oracle?

1091

What happens to the indexes if a table is recovered?

944

What are dml statements in oracle?

1045

What is columnar storage what is the advantage?

986

How to display row numbers with the records?

1025

What are the logical operations?

1066

What is oracle sid?

891

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1873

how to do daily transactions with out sql* loader control file regesterd in apps?

1630

How to count groups returned with the group by clause in oracle?

1012

Can select statements be used on views in oracle?

985

defination of bitmap index

2047

Differentiate between translate and replace?

1040