Is it possible to roll back a sequence to its original point before a
transaction started, if the transaction fails? I need to be able to log
out reproducible SQL from a complex precedure. Oracle 9.2, windows
platform.

I would like to get good tutorial sites for learning PL/SQL. My
background knowledge is academic exposure to SQL and bare intro to
PL/SQL, Database Management System course at auniversity where I
learned normalization, ER model, relational calculus, etc.

I am getting this request from an oracle ODBC driver attached to some PC
based development tools. MS Access is one of them. Regardless, when
there is catalog information needed this statement gets called and takes
10 seconds to resolve on a database that otherwise is quick and

I am using Oracle 10.1.02 version of the Application Server on Windows
2003 server. I had everything working on the box until I rebooted the
machine 2 days ago. The App server is not coming up. As soon as the
machine comes up, I get a window saying that opmn.exe crashed and no

I'll really appreciate if some could help me on a javascript issue
I want to check a form text-box that wheather its an array of
form-fields with same name or its a single
though i think i m asking in wrong room but i know there must b some

Can someone please show me the proper syntax to use here. I'm trying to
create a trigger on a table 'customers', to insert both the id and date_time
in a table called 'custfollow' for each row, before each insert and update.
I'm hung up really on the last part of the statement to ...

I have 2 oracle instance. I need to copy approx 80-90 thousand records
from one oracle database to another on a daily basis. The table
structure is different for both the database. But the mapping for
column from a table in database1 to column in database2 is going to

Hi, I'm trying to run this Perl script against a remote Oracle 10g R1
database. I'm using WinXP and i already have the oracle client software
installed and working.
My Perl version is 5.8.7

We are about to plan our next database server.
(Linux RH 3, Oracle 10.2.0.1.0)
It's got 6 discs, so it's a pretty small system
and we have tentatively decided to go with oracles

I have to copy 2 big tables into one table. I want to do it with "insert
into - select from" but I'm afraid that this would be a to big transaction
for my database.
Whats the way to do such a job?

I've been charged with getting the install CD's together for DR
purposes.  Anyone know where I can download (or buy) the Oracle 8.1.7.3
product.
Any help appreciated.

Oracle 10g, WIN XP, workgroup, no domain!
I've a problem:
create user myuser identified externally;
grant connect to myuser;

hi alls
i am new to this group and found it very valuable.Its my first post
here i go ,thanx for alls in advance.
My first question is When i can create synonym from SQL why not from

10gR2 for Solaris x64 is now on OTN.
<URL:http://www.oracle.com/technology/software/products/database/oracle10g/>
John
groenveld@acm.org

Dear Experts,
I've just inherited some 10G databases running on Solaris.
It's my first opportunity to work with 10G.
I was making sure that everything was ok.