Oracle
in [SQL]
|
Latest updates on SQL server 2008 Find the latest updates in SQL server 2008 tools and techniques. Get details on database management, software testing, flowchart preparation and many more http://www.sqlserversoftware.blogspot.com ... 24 Jun 2008 22:36
V$active_session_history.time_waited Hello What is the unit of V$active_session_history.time_waited? i.e. is it microsecond( 1/1000000 of a second ) or centi seconds (1/100 of a sec)? I could not find this anywhere in the documents. Thanks in advance. -Max ... 24 Jun 2008 20:34
DECODE Hi, I'm looking around for an example of this. Can you update a table with a DECODE statement which gets values from another table? So, something like this: UPDATE table1 SET column1 = DECODE(some value of a select statement....... So, I want to update the column with one of two values depending on th... 24 Jun 2008 16:27
Different databases or different schemas? Hi, Even if I'm using Oracle since some year, I have some (many?) doubts about the use of differents schema instead of different DBs. Generally to manage a test environment, a development enviroment and a production environment, I create 3 different databases on the same oracle instance (MYDB_TEST, MYDB_PROD, MYDB... 25 Jun 2008 13:58
Connecting to oracle (via JDBC) from unix through a firewall geoffeg <geoffeg(a)gmail.com> said: I am trying to access my employer's Oracle server through a Java application (using JDBC thin). "I originally tried ssh -L 1521:$serverIP$:1521 user@$employerShellServer$" but I quickly discovered that Oracle tries to make a second connection back to the client via a random p... 25 Jun 2008 04:43
CASE Statement Hi, I know I can probably do this in an IF statement(s). But, I was wondering if you can have a query with a CASE in it, and later in the query refer to a value eariler in the query. My guess is no, but if I case column 1, and column 2 is based on the value derived from the case of column 1, and so on, is t... 25 Jun 2008 15:00
Could I change the max length of an object name? Could I change the max length limit(30 characters) of an object name? If I could, how? Thank you very much! Jack.Lee ... 24 Jun 2008 16:27
Compatible Parameter after Patching 10gR2 I've recently upgraded to 10.2.0.3 (from 10.2.0.1) on Linux x86_64. My compatible parameter is still set to 10.2.0.1. The patch set documentation doesn't refer to setting the compatible parameter to 10.2.0.3 anywhere. What is the general approach to setting this parameter after applying a patch. Do you set i... 25 Jun 2008 02:41
Expired Certificate in OEM Sorry if this is a FAQ, but I have searched Tahiti, and Googled, but have found nothing of use. I installed Oracle 10.2.0.1 on AIX 5L (64 bit) the other day, and created a small database to test. Enterprise Manager Database Control was configured to use http, and worked. Today I applied the patch to 10.2.0.... 25 Jun 2008 15:00
Oracle Patch - Win 2003 64Bit x86 Hello, I'm looking for the RDBMS 10.2.0.3 patchset for Windows 2003 Server for 64Bit x86 on Metalink. It appears that it it keeps defaulting to the Intel Itanium patchset. I can't see anything that is for 64Bit x86. Has anyone else run into this? I doubt there are no patches for this version. Thanks, ... 23 Jun 2008 12:43 |