From the database level, how can you tell under which time
zone a database is operating?

Answer Posted / naveensarafbecse

SELECT DBTIMEZONE FROM DUAL

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bind variable in oracle 11g?

788


What is the implicit cursor in oracle?

801


What happens to the indexes if a table is recovered?

757


List the parts of a database trigger.

782


What are the numeric comparison operations?

849


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.

1720


What is redo log?

801


Is postgres faster than oracle?

790


What is catalog in Oracle?

875


what is the difference between functional dependecy and multilevel dependency?

2215


How to resolve the ORA-39133 error in Oracle?

796


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1663


What is an oracle user account?

761


How to use values from other tables in update statements using oracle?

836


How to select an oracle system id (sid)?

788