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
4267 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 numbers in oracle?

602

What is a tns service name?

550

How to change program global area (pga) in oracle?

595

What are the differences between lov and list item?

570

Explain the use of tables option in exp command.

603

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1649

What are the differences between primary key and unique key?

529

What is the use of oracle?

572

What privilege is needed for a user to create views in oracle?

608

How to save query output to a local file?

570

What is oracle data type?

569

How to define a sub function?

679

What are the execution control statements in oracle?

617

How to pass parameters to procedures in oracle?

585

Explain what are synonyms used for?

625