I'm running queries on an Oracle server over-seas, and unfortunately
the data being returned amount to over a gigabyte's worth.
Interestingly enough, though, zipped up the data are only about 100
megs.

I am just learning about PL/SQL.
From what I've read so far (John Palinski's book - I don't know how
well it stands up against other publications, but it's done sterling
service for me with respect to the Oracle SQL I've been doing the past

I can't run the oracle universal installer (9.2.0.1) on Windows 200
Server which is based on my harddisk, not CD-Roms
Error:
"The Java Runtime Environment was not fount at

Actually there are several nice articles on Oracle Technical Network
devoted  to the same topic. What's new may be said ?
The target of publication is to highlight   the optimal sequence of
steps required to bring Oracle10g (10.2.0.1)   ASM-database up on

Is there some way to avoid redudancy inside SQL queries like :
SELECT someFunction(t.column) FROM Table t GROUP BY someFunction(t.column)
with something like:
SELECT someFunction(t.column) AS result FROM Table t GROUP BY result

I have just installed oracle 9i on windows 2003 but sqlplus & OEM keeps
crashing...the only way is to reboot the pc and restart sqlplus, this
is not acceptable, is there a patch I can use?
It doesn't happen on windows 2000 server?

I am using Oracle Spatial to store GIS data, and I would like a way to
create Shapefiles from this database.  Does anyone know if this can be
done?
Oracle can use Java classes, so are there any free Java libraries that can

Im on Win2k3 server Standard Ed.
Oracle9i ( 9.2.0.6 )
Creating several temp tables that are transaction specific.
Im noticing that after executing the ddl for these tables and viewing

Calling all SQL experts!
How can one do a select for this:
I have a  table with (for brevity) 2 columns.   RecID and ParentID.
All absolute or generation 0 PARENT records will have a ParentID of 0

Hi NG,
same data different problem.
Plattform:     Windows 2003 Server
        Oracle 10.1.0.3

Hi NG,
the following situation:
I have a datafile with following format:
Aug 05 97.865      97.865    0.000 97.870S 97.865  97.950  97.665

  As per my understanding the number of consistent gets is the number
of consistent reads from the logical memory. If the data is not
available in the memory then the server process reads the data from the
physical memory and put into the logical memory. My question is so the

Following the annual tradition, I will be hosting a meet and greet for
c.d.o denizens attending OW this year (or even for those living
locally). Daniel Morgan will be co-host. Larry, while not attending,
will graciously buy the first round.

DA Morgan gave me an example of a procedure in another thread (Unions
With Grouping Group Values) in which he uses the decode function.  In my
reference book I'm using for my Oracle SQL, and now some of the PL/SQL I
am learning on my own, the author stated "Oracle is planning to ...

We are trying to solve a strange problem with our web-application
(Web-Server: Tomcat/Apache, Database: Oracle 9.2.0.6).
The Problem is, that at least every day, a session from the database
stops working, but the session is still available and the lock is also