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
5388 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 write an inner join with the where clause in oracle?

1029

How a tablespace is related to data files?

1089

What are the execution control statements in oracle?

1066

How to create a table interactively?

1062

What is a cursor variable?

1099

What is an oracle wallet?

924

How to use attributes of the implicit cursor in oracle?

983

Why do we need oracle client?

924

What are set operators?

1060

Explain how you would restore a database using RMAN to Point in Time?

2127

What are the different types of synonyms?

1114

State the various uses of dbcc command?

1038

What to do if the binary spfile is wrong for the default instance?

1047

Explain joins in oracle?

1021

List out the components of logical database structure of oracle database.

1011