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
5447 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 do I use unicode codesets with the weblogic jdriver for oracle driver?

1079

What is the database name in oracle?

1023

What is oracle instant client?

1029

how to join query for one source type is oracle another source type is sql server ?

2429

Explain an index?

1140

What is snapshot is too old? Give and example for better understand.

1607

Where is the export dump file located?

1163

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1427

What are the different windows events activated at runtime ?

2903

Explain overloading. Can functions be overloaded?

1003

What is a system tablespace?

1086

In the oracle version 9.3.0.5.0, what does each number shows?

1305

How to set a transaction to be read only in oracle?

1095

How to create an oracle testing table?

1075

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122