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
- 5379 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 |
DBMS vs. RDBMS
What are operators in oracle?
How to create an oracle database manually?
What are ACID properties in databases?
How to select some rows from a table in oracle?
what is a view?
How to load data through external tables?
What is oracle latest version?
Explain the use of control file?
What happens to the data files if a tablespace is dropped?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to add a new column to an existing table in oracle?
Oracle General 
