Interested to Buy Any Domain ? << Click Here >> for more details...
How to convert the date format from dd/mm/yyyy to
mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008.
when u use to_char(), it tells the month is invalid. how to
resolve this problem.tel with eg.
- 2 Answers
- 10475 Views
- AppLabs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prabhu
1* select
to_char(to_date('22/05/2008','dd/mm/yyyy'),'mm/dd/yyyy')
from dual
SQL> /
TO_CHAR(TO
----------
05/22/2008
| Is This Answer Correct ? | 21 Yes | 2 No |
What is cluster Key ?
How to fetch the row which has the max value for a column?
Explain the dml?
How index is implemented in oracle database?
When system tablespace is created?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
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?
How are extents allocated to a segment?
What is a cursor and what are the steps need to be taken?
What is oracle host variable?
How to invoke the data pump export utility?
When a form is invoked with call_form, Does oracle forms issues a save point ?
Oracle General 
