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.
Answer Posted / pinki
again convert in back to date using to_date
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can we write insert statement in function in oracle?
How to lock and unlock a user account in oracle?
How to write a left outer join with the where clause in oracle?
What do database buffers contain?
What are the built-in functions used for sending Parameters to forms ?
What is the difference between I and G in Oracle?
How to write a query with a left outer join in oracle?
What is a synonym? What are its various types?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How do I connect to oracle database?
What is the best way to do multi-row insert in oracle?
Explain about your project and its relation to the current job position you are applying to?
Why is oracle so popular?
What is the data pump export utility?
What is using clause and give example?