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 is the difference between a hot backup and a cold backup in oracle?
List the types of joins used in writing subqueries?
What are the original export and import utilities?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Where are the settings stored for each instance in oracle?
What is oracle database client?
Can we protect our pl/sql source code?
How to write numeric literals in oracle?
How to define default values for formal parameters?
Hi Can any one tell me what are the API's used in requisition import.
How to get a list of all user accounts in the database?
How to do a full database export?
How to loop through a cursor variable?
How to view the data files in the current database?
Can we call procedure inside function in oracle?