i have a query which returns me an xml of the rows using xmlagg
i want to limit the rows it return , which is not the problem (using
rownum < num)
the problem is that i want to combine in the same sql , the real rows

I  seem to be hitting an issue trying to assign a bind variable to
substitution variable in PL/SQL block - no problem in plain old
SQL*Plus.  Here it is:
--------------- using PL/SQL (does not work)

have a problem :
1. I have many files (txt) on the client with particular format, which
are filled up online
    from time to time and I can't manually turn "att1, att2, ... ,

I am using Oracle 10G with Locally Managed Tablespaces with the
AutoAllocate option.  My Question is the following:  Does it matter
what is the INITIAL extent on the tables that I create in a LMT.
With the AutoAllocate option, Oracle will take care of the extents size

A few months ago I've had several conversations with people on various
forums about building an open source tool for database version
management, a sort of source control tool for RDBMSes. I've worked
quite a lot on it since then, and I think it's more or less ready to be

I need to move a datafile from one disk to another. I am running
Oracle 9.2.0.4 on HP-UX11.  I have done it before one a test system
where I could control the access.  We run SAP and in the test system
I could make sure there were no users BUT SAP was still up.  The

what is the difference between th DBMS and RDBMS?
will be appreciated if they use,general terms....
Bye

I am trying to do an advance replication between 2 machines. I am
trying to replicate the contents (tables) belonging to a specific user
on instance A located on machine 1 to an instance B on machine 2. I am
runnig to scripts on each machine to do this task. the first script

  Does anyone have any documentation on implementing oracle in HA
cluster.
Thanks

I continue a thread started 24 november 1995 (see google archive) and
continued on 23/09/1999
Could anyone try the following queries and tell me if the bug is still
appearing in the RBO. That bug was suppose to be fixed in 1999-2000 (I

although the description of my problem is a bit long, I hope you could help
me.
I would like to compute the nearest neighbor of a point being located on the
surface of the unit sphere.

I have a procedure which is very slow.
This is because it works by letting the user pass in nulls to indicate
that they do not have information on a particular column, if they pass
in a null then the column is not included in the where clause.

Am absolutely newbie to databases, I got some tutorials for Oracle,from
our  school site.
I have Oracle 8.0.5 kit ( April 1998 release ), I get it quiet hard
because I have a poor connection to Internet, and have  just a  few

My error is this..
ORA-00604: error occurred at recursive SQL level 1 ORA-01003: no
statement parsed
I beleive this error is happening because my SQL statment is to large,

Morning all,
After being away from Oracle for many years, I'm once again managing an
Oracle instance. So, while I'm still trying to dust off some old memory
cells in my brain, I have this question.