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
5374 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

How to convert characters to times in oracle?

1070

How to delete a column in an existing table?

1130

What is an index associated with a constraint?

1085

How to pass parameters to procedures in oracle?

1080

What is data file?

1149

What is columnar storage what is the advantage?

1119

What is the minimum client footprint required to connect c# to an oracle database?

1161

How to use "out" parameter properly?

1123

How to call a stored function with parameters?

1092

What the is the diff between local index and global index. give some example.

1681

How to create an oracle database manually?

1129

Explain drop constraint oracle?

1120

What is a trigger oracle?

1136

What is the implicit cursor in oracle?

1169

How many memory layers are in the oracle shared pool?

1253