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
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
How do I connect to oracle?
State some uses of redo log files?
What is control file used for?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what are archived logs?
Explain about achiever in sql?
What is not equal to in oracle?
What is SQL Tuning Advisor in Oracle?
What happens if you set the sga too low in oracle?
How to end the current transaction in oracle?
What happens if you lost a data file?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is dynamic proxy?
What are a query and state the different types of queries and their uses?
Is insert autocommit in oracle?