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
3185 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

Explain enable novalidate constraint.

0 Answers

How do I start tns listener?

0 Answers

Can I create users through internet explorer in oracle 10g?

0 Answers MCN Solutions,

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers

how to genarate random numbers in oracle for particular row?

3 Answers

How to start an oracle instance?

0 Answers

Explain the features of oracle?

0 Answers

How to turn on or off recycle bin for the instance?

0 Answers

What is data block in Oracle?

0 Answers MCN Solutions,

How to Select second Maximum salary in a Table ?