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
- 5572 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 sharded cluster?
How to loop through a cursor variable?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
What is the difference between truncate & delete command?
What are the commands youd issue to show the explain plan for select
how to find find & delete duplicate rows from two different tables?
How to create a table index in oracle?
How many categories of data types in oracle?
After using set unused can we enable the column again to use? Please give me some answers....
what is primary key?
Who i will insert 1 lacks record in a Database table
How to invoke the original export import utilities?
Oracle General 
