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
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
What are the varoius components of physical database structure of oracle database?
What do you know about normalization? Explain in detail?
Does oracle partitioning improve performance?
What do you mean by a tablespace?
When system tablespace is created?
 What are the oracle DML commands possible through an update strategy?
What are the parameters that we can pass through a stored procedure?
Differentiate between post-database commit and post-form commit?
Explain the use of ignore option in imp command.
How do I call oracle stored procedures that take no parameters?
What is meant by raw datatype?
Explain view?
What is the use of file param in imp command?
Explain the use of show option in imp command.
Explain the use of tables option in exp command.