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 build data dictionary view an new database?
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
What is a data dictionary and how can it be created?
what are the advantages of running a database in archive log mode?
What is a snapshot log?
Can multiple cursors being opened at the same time?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
What are transaction isolation levels supported by oracle?
Difference between NO DATA FOUND and %NOTFOUND?
Can you create a synonym without having a table?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
What is the difference between primary key and unique key and foreign key in oracle?