If server is in US and client is in india there is timezone
is diffrence, How can we display date in indian time when
data is displayed from US server timezone?
Answer / nithya
u can use 'to_char' function.
to_char('us date','indian date format model')
| Is This Answer Correct ? | 1 Yes | 4 No |
what is the dual table in oracle?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is the difference between Delete, Truncate and Drop in Oracle?
why can't we assign not null constraint as table level constraint
What is a trace file and how is it created in oracle?
What is Trace File ?
How to end the current transaction in oracle?
How do I manually create a database in oracle?
What is Hash Index?
what is trigger?
is there a tool to trace queries, like profiler for sql server?