select substr(filename,1,instr(filename,'-',1,1)

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

Question Posted / ajit nayak

3 Answers
5304 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / ajit nayak

select substr(filename,1,instr(filename,'-',1,1) - 1) from dual;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to run queries on external tables?

990

What is logical backup in oracle?

969

What are the data types in oracle?

982

What is SQL access advisor in Oracle?

1138

Is a rollback possible to any savepoint?

1002

Can objects of the same schema reside in different tablespace?

1002

Why we use bulk collect in oracle?

973

How to handle a single quote in oracle sql?

975

What are the general rules on data consistency?

960

How to loop through a cursor variable?

1014

Why does oracle 9i treat an empty string as null?

979

What happens to the current transaction if the session is killed?

927

State some uses of redo log files?

947

What is a proxy object?

1011

What is recovery manager(rman) backup in Oracle?

1127