Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 5444 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
How do I uninstall oracle client from windows?
What is a proxy object?
How would you begin to troubleshoot an ORA-3113 error?
How would you change old and new values in an insert, delete and update triggers?
What is the relation of a user account and a schema?
What privilege is needed for a user to delete rows from tables in another schema?
if you ctreate table identity
How many types of tables supported by oracle?
various types of hints and their usage
What are group functions in oracle?
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?
What is enter substitution variable in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Explain about functional dependency and its relation with table design?
Write a trigger example in oracle?
