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.
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 |
In oracle there is column command, how will you explain that?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
what is dynamic SGA and static SGA
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
what is null value?
What happens if you set the sga too low in oracle?
What is self-referential integrity constraint ?
How to sort the query output in oracle?
WHT ARE THE AGGREATE FUNCTIONS?
How to use subqueries in the from clause in oracle?
Explain an index?
How to create a table index?