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
- 5145 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 are various constraints used in SQL?
What is a materialised view?
Difference between oracle's plus (+) notation and ansi join notation?
Explain how are indexes update?
structural difference between bitmap and btree index ?
what is the syntax of DROP command?
How to select all columns of all rows from a table in oracle?
What is private procedure oracle?
How to turn on or off recycle bin for the session?
What are the varoius components of physical database structure of oracle database?
What is difference between SQL and SQL*PLUS?
What are the set operators union, union all, minus & intersect meant to do?
Oracle General 
