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 |
How to generate query output in html format?
What are the parameters that we can pass through a stored procedure?
What is Data Block ?
can any one help me with import/export options in oracle............
What is a subquery?
How to create a table in a specific tablespace?
Explain a private synonyms?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is a table index in oracle?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
What are Clusters ?