I want to use a nested sql using decode.
I have given the following command:
SELECT  A.TYPE,
(SELECT SUM(DECODE(TYPE,'HOT',1,0)) HOT_CAKE,

On a pair of separate Linux boxes, instances or 9.2 (prod) and 10g (dev),
would prefer a solution that could work on both versions.
I use a cron'd PL/SQL procedure which calls DBMS_MVIEW to refresh a series
of materialized views each night - complete refresh needed on most as

I am trying to transform a simple xml node using the  XMLType transform
function in Oracle 9i.  However, the returned "transformed" xml is an
exact duplicate of the stylesheet.  The code is below.  Note:  many of
the elements are optional and I only included some in the xml node.

How to do data entry in Oracle database?
Do I have to design forms for dataentry using a programming language
like VB or Java?
Please tell me a software which is FREE and will let us do data entry

Looking for recommendations from people who use any of the pl/sql formatting
utilities out there... seems to be quite a number available... I tried an
online one and it introduced errors in the code where no errors existed
before. One with a JDev plugin would be nice but not ...

Versions  of Oracle and UNIX are  not relevant. But I work on HP UNIX
using Oracle9i.
When writing shell scripts, I use Unix's here document, e.g.,
Sqlplus /nolog << !

I am using Oracle 9.2.0.5 on HP UNX 11i. An Oracle error occurred at
some point in the past. I want to find what sql statements might have
caused the problem. Is there a way to find sql statements run between
two points of time by looking at v$ views.

I am usin Toad 7.5, connecting to an Oracle10g database. When I go
under Database->Schema Browser, it does not show any tables, indexes
etc.
Outside of Toad when I connect using sqlplus with same username, I can

I installed a 10g R2 database on a standalone Solaris 9 box.  We have
since hardened the machine, and have put it up on the network.  Since
putting it up, I am not able to connect to the database remotely
(sqlplus, golden, toad, etc.).  The error I receive is a

Hello world,
I am looking for a simple nice GUI frontend for Oracle DBs (Version
9.2.0.7) that will let me display the DB structure
(tables/dependencies) and review the data entries. Ideally with the

I wonder if you can help to understand this.
Cannot desc on a table unless I include the owner, but I can do a
select without it. (T_USER table)
Look for synonyms and don't see any defined against the table.

All,
Is there one simple query that could be used to search all tables in
the dictionery to find every occurance of the value...let's say "xyz"
or the number 25.

I want OCP previous / Model Papers (at Least 20 full Papers)

Running 10g Release 2 on Win2K.  So far, it seems rather nice.  The new
Enterprise Manager seems a step up from the java tool under 9i.  My question
is can it be secured via SSL?  I have found instructions in the docs to SSL
enable the full-on OMS and grid control, but thats not ...

I have been a software developer for the past 10 years now. I get job
descriptions that requires problem-solving skills as one of the most
desirable skills in a candidate. But there are not many resources that
is devoted to this topic.