meta user
network profile
| bio | website | ddbcinc.com |
|---|---|---|
| location | Rochester Hills, MI | |
| age | 36 | |
| visits | member for | 2 years, 4 months |
| seen | 3 mins ago | |
| stats | profile views | 364 |
Oracle ACE
|
May 22 |
answered | Oracle database and data has been corrupted. Is there a way to get it back? |
|
May 21 |
comment |
Need an Oracle query to get the Oracle Home directory for a particular instance When you say "Oracle query", are you talking about a SQL statement? Or are you talking about a script that runs at the operating system level? The latter would seem much more reasonable. Are you assuming that the DBA didn't follow any sort of logical process in setting up the server? Or can we assume that things were configured logically? |
|
May 20 |
awarded | Constituent |
|
May 15 |
answered | How to load .dbf to run select queries? |
|
May 13 |
awarded | Caucus |
|
May 13 |
answered | How to use database users as a foreign key field in any table |
|
May 3 |
comment |
Timezones in Oracle 10 @VincentMalgrat - I updated my answer to show that the results are returned based on the session's time zone. |
|
May 3 |
revised |
Timezones in Oracle 10 added 1098 characters in body |
|
May 2 |
comment |
Timezones in Oracle 10 @DylanKlomparens - I updated my answer. You can't just do an AT TIME ZONE on a plain TIMESTAMP assuming you want the time component to change. Either you actually have a TIMESTAMP WITH TIME ZONE or something else is going on. |
|
May 2 |
revised |
Timezones in Oracle 10 added 1517 characters in body |
|
May 2 |
answered | Timezones in Oracle 10 |
|
May 2 |
comment |
Timezones in Oracle 10 @DylanKlomparens - I guess the database could assume that any TIMESTAMP is in the database time zone. But it doesn't. If you specify TIMESTAMP rather than TIMESTAMP WITH [LOCAL] TIME ZONE, you specify that you don't care about the time zone. How much of this is dictated by the SQL 99 standard for those data types and how much is an Oracle implementation detail is not something that I know off the top of my head. |
|
May 2 |
comment |
Timezones in Oracle 10 @DylanKlomparens - The automatic conversion of time zones is something that the TIMESTAMP WITH LOCAL TIME ZONE data type does. You're not even storing a time zone with your data so Oracle has no idea that it should assume that they are UTC. |
|
May 2 |
comment |
Timezones in Oracle 10 What data type are you using to store the data? TIMESTAMP? TIMESTAMP WITH TIME ZONE? Or TIMESTAMP WITH LOCAL TIME ZONE? |
|
Apr 25 |
awarded | Enlightened |
|
Apr 24 |
answered | Is the data fetched by an explicit cursor immutable in PL/SQL? |
|
Apr 23 |
comment |
What is a partitioned view? @SuhailGupta - The documentation I linked to walks through a complete example. That is probably easier to follow than any summary I could come up with. |
|
Apr 22 |
awarded | Nice Answer |
|
Apr 21 |
answered | What is a partitioned view? |
|
Apr 15 |
reviewed | Approve suggested edit on getting error when i use merge statement |
