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
- 10398 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 |
Can you create a synonym without having a table?
Difference between the “verify” and “feedback” command?
why dont we assign not null constraint as table level constraint.
What is key preserved table?
How to connect ms access to oracle servers?
Describe the different type of Integrity Constraints supported by ORACLE ?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
What privilege is needed for a user to create views in oracle?
What is a table index?
Can we call a trigger inside a function and function inside a trigger? Give example.
What are a collation and state the different types of collation sensitivity?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Oracle General 
