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
- 3 Answers
- 5571 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
Briefly explain what is literal? Give an example where it can be used?
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
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is meant by an index?
How to get a create statement for an existing table?
Explain drop constraint oracle?
Why oracle is used?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Differentiate between function and procedure in oracle.
How do I know if oracle client is installed on windows?
What is columnar storage what is the advantage?
what is normalisation?what are its uses?
Explain the use of rows option in exp command.
What to do if the startbd.bat failed to start the xe instance?
What is the difference between 10g OEM and 11g OEM?
