Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 5273 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / ajit
select substr(file, 1, instr(file, '_',1,1) - 1) file, data from <table name>;
| Is This Answer Correct ? | 1 Yes | 0 No |
What is a table index in oracle?
How to best split csv strings in oracle 9i?
Is java required for oracle client?
What is Rollback Segment ?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
What is private procedure oracle?
what is exact difference between drop and truncate table.
How to define an anonymous procedure without variables?
without using count(*) and rownum how can we count total record in a table
What are ACID properties in databases?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Oracle General 
