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
- 5302 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 can you use check constraints for self referential integrity?
What is an Oracle sequence?
What are ddl statements in oracle?
How to define a sub function?
How to assign data of the deleted row to variables?
How to insert multiple rows with one insert statement in oracle?
Which are the five query types available in oracle?
Explain the truncate in oracle?
how to get the index id?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What language does oracle use?
Oracle General 
