select substr(filename,1,6),data from table1; tjis is ur solution ..

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 / david

3 Answers
5387 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / david

select substr(filename,1,6),data from table1;

tjis is ur solution ..if any confusion regards this question
plz post there...

thanks
gunjan david

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to divide query output into groups in oracle?

974

Explain cascading triggers.

1056

How to list all tables in your schema?

1024

How index is implemented in oracle database?

980

How to store pictures on to the database?

953

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2045

what is Single Byte Overhead...?

2536

How to update values on multiple rows in oracle?

1016

What are ddl statements in oracle?

1047

What are the data types in oracle?

1018

ABOUT IDENTITY?

2032

Which is faster join or subquery in oracle?

973

Explain constraining triggers.

1068

Explain integrity constraint?

1142

What are the original export and import utilities?

1136