select substr(file, 1, instr(file, '_',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

2 Answers
5264 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / ajit

select substr(file, 1, instr(file, '_',1,1) - 1) file, data from <table name>;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

989

Give the various rollback segment states.

1052

What is a named program unit?

1086

Why do we need integrity constraints in a database?

1022

What are privileges and grants?

1067

How do I uninstall oracle 11g?

1120

Can we create trigger on materialized view in oracle?

993

what are the advantages of running a database in archive log mode?

2204

what is insert all statement in sql

6520

Â How to use an oracle sequence generator in a mapping?

1076

Please explain drop constraint oracle?

1108

Explain the dml?

984

How to assign data of the deleted row to variables?

1075

What is a view and how is it different from a table?

1048

How to establish administrator authentication to the server?

1043