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

Can we use bind variables in oracle stored procedure?

896

What are the limitations oracle database 10g xe?

974

How to empty your oracle recycle bin?

979

What is raw datatype?

1075

What are the different types of database objects?

990

List out the difference between commit, rollback, and savepoint?

985

How does one get the view definition of fixed views/tables?

966

What are the different types of modules in oracle forms?

949

How to create a temporary table in oracle?

1189

What are dml statements in oracle?

1039

How do we display rows from the table without duplicates?

918

How to calculate date and time differences in oracle?

987

What do you mean by merge in oracle and how can we merge two tables?

1000

What is a table index in oracle?

1063

Explain an integrity constrains?

1074