Table1- have two column filename data AFGDFD-20112011 hi how r

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 / rody

2 Answers
4206 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 ..

Answer / 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

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 ..

Answer / ajit

select substr(file, 1, instr(file, '_',1,1) - 1) file, data from <table name>;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer