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
- 5392 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 are different types of locks?
What are main difference between Stored Procedure and Functions.
How to create a new tablespace in oracle?
What is where clause in oracle?
What are the different types of trigger and explain its various uses and functions?
Youre getting high busy buffer waits - how can you find whats causing it?
Why cursor variables are easier to use than cursors?
Where do we use decode and case statements?
Can a primary key contain more than one columns?
What is oracle analytical function?
What is difference between SUBSTR and INSTR?
what is the scripts in data base?
Oracle General 
