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

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

Question Posted / venkateswararao

1 Answers
3079 Views
I also Faced
E-Mail Answers

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

Answer / naveensarafbecse

SELECT DBTIMEZONE FROM DUAL

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

what are the disadvantages of hierarchial database over RDBMS?

1 Answers TCS,

What is Read-Only Transaction ?

3 Answers

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

0 Answers Wipro,

what are the things that you consider while creating indexes on partitioning tables?

1 Answers

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

0 Answers Atos Origin,

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers IBM,

What is an UTL_FILE.What are different procedures and functions associated with it?

1 Answers

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

1 Answers

Explain the use of grant option in exp command.

0 Answers

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

0 Answers Cisco,

what is pragma?

2 Answers

How to define an oracle cursor variable?

0 Answers

For more Oracle General Interview Questions Click Here