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

List out the types of joins.

1139

What are the parameters that we can pass through a stored procedure?

1051

Can we commit inside a function in oracle?

946

Give the different types of rollback segments.

1018

Give the constructs of a package, function or a procedure.

1020

What is bind variable in oracle 11g?

1026

What is the difference between a primary key & a unique key?

1075

What is a subquery in oracle?

1090

What is a nested table?

1038

What is concurrency in oracle?

988

How to compare dates in oracle sql?

1088

Can we call procedure inside function in oracle?

1063

How to write numeric literals in oracle?

1165

What is the difference between pre-select and pre-query?

1194

Why do we use coalesce function in oracle?

1100