I am having trouble pruning branches from a "connect by Prior" query
(oracle 8i)
My table looks like this
create table test_connect_by (

if I have a table and partitioned based it on date. Then how can I
extend the partitions
dynamically ! That is I want to generate a partition everyday !
As the data is very large ! So help me out !

I have a query
SELECT
     DECODE(SODC.CONTRASEQNUMBER, 1, SODC.CONTRAQUANTITY,0) CQTY1,
     DECODE(SODC.CONTRASEQNUMBER, 2, SODC.CONTRAQUANTITY,0) CQTY2,

what I want to achieve:
I want to call an Sql*Plus script which should use the result of one
select statement in the next statement, to be more exact: A "select"
statement should return the partition name, and the second select

    I am very new to the RAC and I need to setup the RAC on our Oracle9i
Windows environment.I woluld be
very greatfull to you all, if you come up with the your experience with
Oracle 9iRAC and share with me. Basically I am in process to understand the

I have a quest.
This query
SELECT /*+USE_NL(nodi) */ nodi.* FROM V_MT_NODI nodi,W_MT_NRL linee
WHERE 1=1 and linee.IL_LINEA=0 AND linee.IK_LINEA=16705 AND

the install docs list Sunspot as a required package. But this package is not
part of the Solaris 10 distribution.
I still managed to installe Oracle10.2 on Solaris 10. But when I tring to
compile ProC sample application using

Our department is loosing access to MS Server 2000.  I am looking into
different possibilities of replacements, Oracle being one.  I know
Oracle is available for free, but I'm not clear what the limitations of
it are, and that's what I need clarified for me please.

I want daily report in Excel format.and this excel file should be
mailed to client.I want autoamtic process for that just like cron job.
I am using Oracle 9i on Linux

We are using Oracle database for our entreprise application. Although I
was in favour for purchasing 2 servers and replication of the database
though SQL.NET, the guys from infrastructure thought they were smarter
and configured the system as a cluster, inclusive an expensive disk

Is there a way to find out how many times a trigger has been fired
during a given time?
ta

Talented and accomplished professionals for our Information Technology
department at our headquarters San Diego, CA.
Our group is working on the implementation of our Oracle systems.  Most
of the positions are senior level, but we also have a Director position

Questions here on internals..
1- How exactly is Oracle or any RDBMS able to select data at the column
level
2- Do RDBMS's store data in an array and does it use pointers or

I am running Oracle 10G on Win 2K3 and have the following situation:
On the server A I installed Oracle database 10Gr2 into the following
oracle_home: OracleOraDb10g_home1. Then I installed Grid Control into
new oracle_home (OracleOraEM10g_home1) with "new database" option. I

I have two things I would like to do: First, access/initialize the
%rowtype of a var programmatically. Instead of having to know the
particular table upfront I would like to assign it dynamically. Also I
would like to iterate the the columns/fields for the data. PL/SQL just