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
5443 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 assign a table row to a record variable?

1040

What is meant by a deadlock situation?

1109

Why do you use stored procedures and state some of its disadvantages?

1028

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

1221

How would you go about verifying the network name that the local_listener is currently using?

2049

Explain the importance of .pll extension in oracle?

1011

What is the difference between hot backup and cold backup in oracle?

1014

What are dml statements in oracle?

1095

How to convert raw data type into text in oracle? Explain

993

Explain cascading triggers.

1074

How to resolve the ORA-39133 error in Oracle?

1122

What is a system tablespace and when it is created?

972

What is a table index?

1098

How to write date and time interval literals in oracle?

1036

How to enter a new row into a table interactively?

1014