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

Difference between open_form and call_form in oracle.

676


What is the use of file param in imp command?

642


How to check the oracle tns settings?

573


What are privileges and grants?

570


What is the usage of control file in oracle?

605






Explain the use of control file?

654


How to estimate disk space needed for an export job?

558


What privilege is needed for a user to insert rows to tables in another schema?

560


Explain oracle data types with examples?

575


How to use select statement to count the number of rows in oracle?

554


What is blob data type in oracle?

557


Is a rollback possible to any savepoint?

556


What is a table index?

561


How to use existing values in update statements using oracle?

545


How to assign data of the deleted row to variables?

579