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
- 5356 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / david
select substr(filename,1,6),data from table1;
tjis is ur solution ..if any confusion regards this question
plz post there...
thanks
gunjan david
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ajit nayak
select substr(filename,1,instr(filename,'-',1,1) - 1) from dual;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mohamed shafee
select left(filename,6),data from table1
or
select convert(varchar(6),filename),data from table1
| Is This Answer Correct ? | 0 Yes | 2 No |
How do I spool to a csv formatted file using sqlplus?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
what is the scenario where you take the database to NoArchivelog mode?
What is dictionary cache ?
What is a Segment ?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to drop a stored function?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Please explain joins in oracle?
What are the varoius components of physical database structure of oracle database?
What is an Index ?
What is difference between truncate and delete?
Oracle General 
