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
5380 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 Tune Query

2347

Explain the use of grant option in imp command.

1083

what is port in oracle? how is it related to database application.

1992

How can we create the complete backup of data in the oracle.

2201

What is the max number of columns in an oracle table?

1049

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2341

How to retrieve values from data fields in record variables?

1173

Explain drop constraint oracle?

1122

How to grant create session privilege to a user in oracle?

1055

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2271

What is dual table oracle?

1030

How to commit the current transaction in oracle?

1188

How to store only time; not date and time?

1070

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4685

Explain what are the type of synonyms?

1188