I have a table which contains a column date_operation declare as date
when I do sql as "select date_operation" from a_table, I got as below:
02-MAR-05
--------------

On my Oracle 10.2, I got the following:
 1  declare
 2  cursor csr is select ename,deptno,
 3  rank() over (partition by deptno order by sal)

Hi group
I am new to Oracle. Does anyone have an ebook on learning Oracle 9i, or
knows any good tutorials online.
Thanx

I have been using RMAN with Veritas NetBackup for a while, and now need
to do the same with Legato. However, it appears that there are
substantial differences:
- Veritas NB agent allows to run any shell script, so from agent

I have a fairly big Oracle 8i database (2 million order rows in the largest
table) and I'm having trouble with the OR operator in a query. For some
reason the OR is causing queries to run dog slow. It's so slow that I have
to take out the OR and use a UNION instead. For example:

I use sql> select column1, column2 from a_table;
I got three output.
But,
if I use perl script as below:

I am running Oracle 9.2.0.5 Personal Edition on Windows2000 (client),
and following the steps for "Adding New Master Sites Without Quiescing
the Master Group," (Chapter 7, Replication Management Guide) which
include the following EXP command:

I currently use Waters' Millennium HPLC software, which has an embedded
instance of Oracle 8i.  Recently the hard disk crashed, and hosed the
connections between the data files and the database,  so the data is now
inaccessible.  Is there anyway to rebuild the database manually ...

Hi, dear all,
Currently we have two Oralce 9i databases in the production
environment. We synchronize them *logically* every day. *logically*
means these 2 databases are not exactly identical, the schemas inside

I am trying to backup 8.16. to another server. (Win)
Runnin the follwing:
RUN
{

When backing up data from large RAM to small RAM (RAM backup ), ORACLE
failed to work with message 'database unavailable'.
Appreciate your help!

What is row migaration?
Does it means that when I select some rowid from a table, and after row
migaration, the rowid may be changed?
Thanks

   We have 2 databases running on 2 IBM p570 Servers. Initally it was
configured to run in shared mode. We have 2 DB link to access each
other and the db level for both databases are as follows.
SQL> select * from v$version;

Hi, all.
Our db (8i on AIX) has tablespaces with different extent sizes, and
once an object in the smaller extent-sized tablespaces reaches a
certain threshold of extent number, we move it into the tablespace with

Hi to all,
is it any way to calculate the length of a very big fields in a long raw
type in plsql?
i found a lot of examples for long fields but i can't find the way for long