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
What is java oracle used for?
What is the scope of a local variable?
How to save query output to a local file?
How to drop a tablespace?
Explain the use of rows option in imp command.
What is Data Dictionary Cache in Oracle?
What is sharded cluster?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How can you merge two tables in oracle?
How to invoke the data pump export utility?
What are the different pseudo commands? Explain in general?
What is logical backup in oracle?
Differentiate between pre-select and pre-query?
How to create a new oracle data file?
What is set verify off in oracle?