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

How to insert a record into a table?

1122

How to get last row id?

1058

How to concatenate two text values in oracle?

1159

What is max rowid in oracle?

1084

How to use windows user to connect to the server?

1046

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2093

What is the recommended interval at which to run statspack snapshots, and why?

2964

In the oracle version 9.3.0.5.0, what does each number shows?

1346

How to export your own schema?

1051

Explain alias?

1193

How to view existing locks on the database?

1103

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1089

What is a package ? What are the advantages of package ?

1138

Explain the use of show option in imp command.

1150

what are steps for interface? where is exchange rate defined in which table?

2239