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
5369 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 sid in oracle?

1032

How translate command is different from replace?

1137

Is oracle a language?

986

Can group functions be used in the order by clause in oracle?

1041

How to define an explicit cursor in oracle?

1090

How to omit columns with default values in insert statement in oracle?

1096

What is execute immediate in oracle?

1074

What is oracle open database communication (odbc)?

1081

How to connect to a local oracle 10g xe server?

1032

Differentiate between function and procedure in oracle.

1149

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2309

How view is different from a table?

1079

Can the query output be sorted by multiple columns in oracle?

1046

Does oracle database need java?

1064

Explain the use of full option in exp command.

1174