I'm new to Oracle (10G), and I'm trying to create a binary tree
structure with a self-referencing table, but I am having some trouble.
Table NODE
  NODEID (PK)

                Sybase has a global variable, @@rowcount, that returns
the
number of rows affected by the previous query.
Is there some equivalent for that in oracle?

I am trying to generate an explain plan from within SAP using their
language called ABAP.  The problem is that I can OPEN the cursor with no
problem but it is not populated unless I do something other than OPEN
it.  If I use the FETCH command shown below, I get: "ORA-01009: missing

I've install oracle 9i with 9.0.2.5 patch on windows 2000 server as
"ABC" user who member windows administrator group.
Then I've create a small database ("DB1") and its listener... and then
opened them. They are working properly and clients are connecting and

I have a table TRAIN_ROUTE which lists the route locations (field
LOCATION_I) in order of field ROUTE_ORDER_I, for a series of trains
grouped by (TRAIN_I and P_VERSION_I).
There is a primary key on TRAIN_I, P_VERSION_I, ROUTE_ORDER_I.

Hello.  If I am writing a select statement and I am concerned about the
performance impact, I'll try to time the sql using the following
'technique':
DECLARE

At college, I am doing a multimedia course (degree level, or
thereabouts)and I have to write five hundred words on Oracle.  I know
very little about oracle, except that it's a high end database engine
generally used by big multinational companies.  As port of the

I'm sure this question has been asked a hundred times, but after looking
into google for a few hours, I have so many books, I really don't know
which one is right.
So I thought, I'll just put some needs here, and see if you can give me

I have installed Oracle 8.1.7 with userid ora817 groupid dba
in /u01/app/oracle/product/8.1.7. running a listener named lsnr817
port 1522
for my Oracle 8 Databases.

I am consulting at an all-Windows shop, running mostly 9.2.0.3 -
9.2.0.6 under Windows 2003 Server.  The one no-no I've encountered so
far is that their SAN array is all RAID 5.  As they have grown by
acquisition, this is an old, old StorageTek unit that supposedly does

I was working on oracle 9.2.0.3 previously and using sqlmap for calling
stored procedures. Everything was working fine.
No I changed my oracle configuration to 9.2.0.7
All of a sudden all stored procedure calls started giving error

I am learning PL*SQL and wanted to populate a new table with values
from four tables in HR database. I the process, I encountered some very
interesting things. For example, the following did not work;
create or replace package body populate_new_tbl is

he
where can I find information about tables which I open during the session in
Oracle DB
t.

Need help on my assignment.... I have finished all ecept the sqlquestion. I
have created an ms access tables but need it in Oracle SQL.  Please help
The question is as below
6. Define normalised relations as SQL tables enforcing all apllicable

Currently, my undotablespace is autoextented to 16G in Oracle 9i. It is
too large to my application, so I want to shrink it to a appropriate
size 4G, I am not sure whether the way  switching current undo
tablespace(16g) to a new one(4G) is the best?