I have been writing a stored procedure and am trying to use embedded
cursors (3 level of nesting) for the first time. My immediate concern
is that, now the data set is small but it is expected to explode and
grow very big in future. All I want to know is that if some one has

Is it possible to use a variable in the select statement which holds
the column I want to select?
So:
declare

I work with oracle 8.1.7 and I wrote the following trigger and
compiled it successfully:
CREATE OR REPLACE TRIGGER
   AV_BB_EINZELPUNKT_EXAKTDEF

Hi Oracle-Gurus,
there is a need to store information about changes on some tables in the
database forever, that means if a user (inserts),updates or deletes a
record it is to protokoll this in database. [1]

I was wondering if anyone runs am Oracle Streams production environment.
If yes, which version of the database and which patches applied.
I asking because I eard that Oracle Streams had some problems on the
begining, and want to make sure I'll start on the rigth version.

Pls help
I have a DBA role privileges. When I try to perform
DBMS_STATS.GATHER_INDEX_STATS on an index which belong to other user, I
encounter insufficient privileges.

I work for an bank and runs an in-house system that calculates
portfolio performance.
There is an upstream system that calculates daily performance. My
system takes these daily performance, and sequentially multiplies them

How i can, execute a .sql file by ftp.
I tried, sqlplus USER/PASS@SID
@ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql
But, don't work.

two tables, one to many relationship. Second table can have duplicate
records.
Want a classic report
master

We need to import data from different database systems into an Oracle
database. The other systems are: MS SQL, Firebird and MS Access. The
data structure is not identical - in one source system, the data might
be in a flat table, in the target system it needs to be distributed

I have a very large table with many columns that can cause this. Input
is coming  through external application integration and we do not have
control on code that inserts data in our table. We can however change
precision in the table.

Is it possible for a dba to deny connections to its database, made via
dblinks ?
I mean, if user A has create database link privilege in db1, and
wants to make a dblink to db2 with certain user, can the dba from db2

Easy DVD Copier 3.3
http://www.soft30.com/softdown-11-16095.htm
Easy DVD Copier is a quality and extremely fast DVD copying tool. It
recodes all DVD and copies them to your hard disk or burns them to DVDR

I have installed oracle 9i database on Windows XP. Oracle database is
running well and through sql plus command prompt i can aceess database
and execute query. Also i installed Forms Developer 9i on the different
directory other than the oracle 9i database home directory. When i run

Hi. I have an application which makes several (10-50)
separate JDBC connections to an Oracle DBMS, and uses
these connections indefinitely. Can you tell me any
reason I would prefer or care about whether the DBMS