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

How to define an anonymous procedure with variables?

545


What is a package ? What are the advantages of package ?

605


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1848


Difference between cartesian join and cross join?

543


What is difference between truncate and delete?

563






Can you drop an index associated with a unique or primary key constraint?

587


Explain the dml?

600


What suggestions do you have to reduce the network traffic?

551


What is program global area (pga) in oracle?

609


6. Display the client name and order date for all orders using the traditional method.

1753


what is difference between sql plus and sql*plus? (not sql and sql plus).

3350


How to load a large xml file?

586


What is a nvl function?

566


Differentiate between post-database commit and post-form commit?

545


What is dual table oracle?

527