We have a customer who has a 8.1.7.3 database created with a db
character set of WE8ISO8859P1.  They have been using this database for
a few years and while the data in there is 80% english they also have
been putting Chinese (HK - traditional characters) into this database.

Question:
Say I have 3 weeks of backup, and I want to get rid of everything but
one week.  Will this REPORT command give me a list of everything I can
delete:

we have an urgent problem with our Oracle 9i Server. After we
compressed the tablespaces we experienced the following problem:
The database instance is always shutting down itself.
We looked into the Alert-File and found that Oracle is no longer able

I am a programmer with extensive exposure working with Oracle
databases. However, up until now, I have been working with databases
that were either designed without my input, or for other applications.
This is my first forray into the actual design of the database.

Can a 3-d database be built using Oracle?

Well, Buying a collection is always useful and result is fruitful. I have
made 3 test collections for oracle and got total of 20% discounts at all.
I know the real exam is so much difficult. you should have the knowledge
about whole exam topics. Although ucertify simulation test ...

I'm calling SQL*Plus to run a query from inside a Unix (ksh) script.  How
can I tell whether the query returned any rows or not?

Apart from Oracle, which databases support the "start with" and "connect by"
clauses for hierarchical query?  Does MySQL and MSSQL support them?  Are
their syntax portable with Oracle?  I just need to evaluate this before
using these clauses in my oracle application - for ...

Consider the following SQL*Plus:
SQL> select row_id from CX_LOCK;
ROW_ID
---------------

i've to optimize a sql statement for a customer. There are inner join and
join.
Is there any documentation which I can read in order to know how to do it.
The statement from an mssql server doesn't work.

Vennela Technologies is a Global Oracle Technologies and Oracle
Applications services Provider with a good customer base in Middle East
and Europe
Vennela started its Training division very recently. We are very happy

Can someone please tell me what I am doing wrong.  I can't get it to
suppress the command echo in the spool file or suppress the terminal output.
I'm sure it's something dumb, but I've been struggling for hours on this and
need help.

i have a query that i need help on.  basically i need to choose all the
customer keys that have the sum of the sales amt * qty > 100000.  i get
an error message saying that i canno?t have the sum in the group
function.  is the below the correct syntax?

Hello. I have a table that stores readings from temperature sensors
every 15 minutes. My problem is that one of them had a problem and kept
reading the same temperature for a couple of days. Luckily (and
surprisingly), this particular one is one of the few that had a backup

I need to develop some Unix (ksh) scripts to run on a HPUX system, but I'd
like to do the work on windows.  I tried something called "UWIN" which
almost works, but I can't get it to run SQL*Plus.
Anyone have any luck doing something like this?  Is there another way to get