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
5278 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 the is the diff between local index and global index. give some example.

1647

What are the original export and import utilities?

1186

Can a formula column be obtained through a select statement ?

2335

How to create a stored program unit?

1238

How to rename an existing table?

1136

How to create a temporary table in oracle?

1280

defination of bitmap index

2135

Explain alias?

1156

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1018

Explain the use of rows option in imp command.

1093

Differentiate between translate and replace?

1128

Explain the use of rows option in exp command.

1103

How to bring a tablespace offline?

1074

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

1068

What is query image?

985