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
5268 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 proxy class?

1059

What is tns name?

981

How to name query output columns in oracle?

1188

What do you mean by a deadlock?

1066

What are the various types of snapshots ?

1030

What is SQL access advisor in Oracle?

1194

What is the sid in oracle?

968

What happens if you set the sga too low in oracle?

1155

Explain an extent?

1109

How to create a new table in oracle?

1159

How to connect to oracle using service name instead of sid?

1027

How to experiment a data lock in oracle?

1057

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1950

What do you mean by merge in oracle and how can we merge two tables?

1051

What happens if variable names collide with table/column names?

1193