select left(filename,6),data from table1 or select convert(varchar(6),fi

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 / mohamed shafee

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

Answer Posted / mohamed shafee

select left(filename,6),data from table1
or
select convert(varchar(6),filename),data from table1

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is meant by magic query

2183

Explain an index segment?

1117

What is sequence?

1078

Explain parameter file in oracle.

1027

How do we get field details of a table?

978

What are the uses of Database Trigger ?

1715

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2268

Is java required for oracle client?

996

Explain the characteristics of oracle dba?

1118

What are operators in oracle?

1053

How do I start tns listener?

1040

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2256

What happens to the data files if a tablespace is dropped?

1059

What is oracle open database communication (odbc)?

1028

How to load data from external tables to regular tables?

1062