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
- 3 Answers
- 4348 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ajit nayak
select substr(filename,1,instr(filename,'-',1,1) - 1) from dual;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an oracle database?
How to create an oracle database manually?
Can select statements be used on views in oracle?
is there a tool to trace queries, like profiler for sql server?
How to use null as conditions in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to retrieve the count of updated rows?
Does facebook use oracle?
How to create lov dynamically at runtime & attach to text field?
Name the three major set of files on disk that compose a database in Oracle?
Explain compound trigger in oracle?
What is a proxy object?
How to create a new user account in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
Design database draw er diagram for a certain scenario ?
