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
- 5375 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 the usage of save points in oracle database?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What are the different types of modules in oracle forms?
What is the relationship among database, tablespace and data file?
What is a cursor variable?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
how to find find & delete duplicate rows from two different tables?
What is an oracle data file?
What is meant by raw datatype?
How to delete multiple rows from a table in oracle?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
Oracle General 
