Apologies for cross-posting, but I expect my search to be difficult, and
any responses to comp.databases.oracle.marketplace *ONLY* please, or to me
by email - geoff dot muldoon at gmail dot com.
I'm currently involved in a project prototyping (successfully so far) the

I am usint 10g.
I know that you can put a decode in the order by section. But I tried
to see if it is possible to put a case statement in the order by
section. My little experiment did not work.

I've created a trigger using the script below.
whenever I fire it by the statement
update site_control_t set oid = oid;
I  get

Guys,
I need help with a Oracle E-Business install on a test system (Windows
Vista) on my PC at home..
This is basically a test system for learning purposes only.....

Hi group,
I'm just wondering - and I tried to look it up in the documentation:
When I submit a dbms_job calling a pl/sql-procedure and this procedure
does some data-changes - is it for sure that this changes are

I am the happy heir of a server running Red Hat Enterprise 3 with Oracle
10.2g. This server is used for integration purposes. Every night, the prod
db is exported to a dump file using expdp, and then we use impdp to import
the schemas, one after the other. The export (5GB) is ...

Oracle DBA/Apps DBA
Location(State/city): NY/NJ
Duration: 6 Months
Req Details:

First of all I have no experience on Oracle. I'm simple programmer
with task out of my skills.
I was given task to restore database to a new location with few simple
commands.

Does anyone know if it is possible to instal Oracle 8i personal to a
PC tha only has 10g, or will I have to have to install oracle 8i as
well.

I am new to Oracle.
For a project at my work we need to model our system. The system will
be developped with an Oracle (9i, 10) database.
Now I want to create a personal oracle database on my personal

This is a question on 10g analytic functions
I have Table T1 with four number columns:
Table T1:
id    X    Y    Z

Have a  10G server on solaris 10 sparc with 16GB.
An alarmed user has pointed out that the memory usage look very high.
I dunno whether the memory usage is just high or too high because dont
have previous experience on sol10/10g.

hi ng,
sorry for the subject, it is a difficult to write it in two words.
<oracle 9.2.0.7/9.2.0.8; cost based optimizer; VMWare ESX- server; MS
Windows>

hi group,
first off, thanks to Steve Howard and  DA Morgan for helping me out on my
last post. much appreciated.
my question today refers to these statements in the oracle documentation for

Our company is running Oracle 10g 10.2.0.1.0.   We want to and need to
upgrade to the latest patch.  We logged onto Metalink and in the
Simple search used these parameters:
- Oracle Database Family