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

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5579

Please explain compound trigger in oracle?

1069

What is bind variable in oracle 11g?

1043

What are the different windows events activated at runtime ?

2909

List out the types of joins.

1172

How to loop through data rows in the implicit cursor?

1082

How to convert numbers to characters in oracle?

1037

Why do we need integrity constraints in a database?

1030

Explain alias?

1156

How do I escape a reserved word in oracle?

1210

What is difference between truncate and delete?

1051

How can Oracle users be audited?

1128

How to assign query results to variables?

1060

What do you know about normalization? Explain in detail?

960

How to see the table columns used in an index?

1033