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
- 10481 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 are the differences between number and binary_float in oracle?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
What is data block in Oracle?
How to define Data Block size ?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is the purpose of save points in oracle database?
What to do if dba lost the system password?
what is pragma?
How to resolve the ORA-39133 error in Oracle?
How to connect to a remote server?
What is a Data Dictionary ?
What is the difference between substr and instr?
Oracle General 
