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
- 4293 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
Explain the use of Merge statement in oracle 11g
When do I need to use a semicolon vs a slash in oracle sql?
What is the difference between Delete, Truncate and Drop in Oracle?
How does Oracle guarantee data integrity of data changes?
Can we commit inside a function in oracle?
How to export data with a field delimiter?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is bulk copy or bcp in oracle?
What is a oracle database?
what is IDE,DMV in sql server?
Why do you create or replace procedures rather that drop and recreate.
What is the difference between pre-select and pre-query?
How does one get the view definition of fixed views/tables?
Explain an exception and its types?
