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
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 an Oracle Instance?
What is a sub query? What are its various types?
What is tns service name?
What is the difference between a primary key & a unique key?
How to define and use table alias names in oracle?
How to name query output columns in oracle?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
how to find count rows in table without count function?
What are dml statements in oracle?
What are the differences between char and varchar2 in oracle?
Explain the use of analyse option in exp command.
26. Display the earliest shipping date in the format: DD/MON/YYYY