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
- 5279 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 |
Can Multiple instances be run on Single Machine???
How to turn on or off recycle bin for the instance?
How to view the tablespaces in the current database?
How many types of database triggers exist?
Why we choose emp number as primarykey?
What are the differences between lov and list item?
how to find full database size
1 Answers BirlaSoft, Consultancy,
What is a nvl function? How can it be used?
How to write an inner join with the where clause in oracle?
How would you change old and new values in an insert, delete and update triggers?
What is data block in Oracle?
What is a lookup table in oracle?
Oracle General 
