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
- 5458 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 |
What is the use of oracle?
Is oracle a programming language?
What is a Temporary Segment ?
What is the difference between a primary key & a unique key?
How to export several tables together?
What is a Data Dictionary ?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
how to use sequence and what use of sequence cache
What is object data modeling?
Explain joins in oracle?
DBMS vs. RDBMS
What are the different windows events activated at runtime ?
Oracle General 
