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 can windows applications connect to oracle servers?
What is the implicit cursor in oracle?
What is a materialised view?
how many columns can a plsql table have
Is there any function in oracle similar like group_concat of mysql?
How many types of tables supported by oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
The join defined by the default data link is an outer join yes or no ?
What's dateware house and what's clustor with practicle example
What is Index and different types of Indexes?
What is the relation of a user account and a schema in oracle?