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
- 5305 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
Explain the use of grant option in exp command.
What is the meaning of recursive hints in oracle?
What is data file?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How can we force the database to use the user specified rollback segment?
What is oracle datasource?
What is the data type of dual table?
What is tns service name?
How to use "startup" command to start default instance?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is the database name in oracle?
How can I get column names from a table in oracle?
How can I see all tables in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is meant by joins? List out the types of joins.
