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
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
How many types of database triggers exist?
How to get maxsal , minsal, ename department wise in single query
What is the parameter mode that can be passed to a procedure?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to experiment a data lock in oracle?
How to rename a column in an existing table?
How to update values on multiple rows in oracle?
How to shutdown your 10g xe server from command line?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How do I spool in oracle?
How many memory layers are in the oracle shared pool?
How a database is related to tablespaces?
How to convert a date to char in oracle? Give one example.
How oracle handles dead locks?
Why oracle is used?