Is there a way to run a SQL in a RAC instance #1 from instance # 2 ?
thanks,
i.d.

Using Oracle 9i -
Using PL/SQL
Is there a command like SQL's show table command that will show all
the information for a specific table, like the table columns & size,

I need help on database design which can manage many to many
relationship between "N" number of tables. for last 2 days i'm
thinking over this but not able to find a solution it will be great if
someone can help me.

Our organisation is using an off the shelf application which has an
Oracle database back-end.  We have a licence for 10 concurrent users.
We now need to have additional users access the data for view purposes
only.  As the cost of increasing the licence count is prohibitive are

I am SQl DBA professional working since 2 years and I also want to
work on Oracle.
So, Please suggest me that should i start with Oracle 9i or Orcale
10g.

hi all i want to generate the total sales of the 3 most sold products
of a firm, i ll try to write it here
as follows from more than one table but the result i am getting is
awful, and has nothing to do with the real thing; take a look please

Good day,
Whenever a transaction reads a block, it compares its SCN with the
transaction's SCN, and based on whether the block's SCN is >
transaction's SCN it will replay undo data until the final data are

I have a stored procedure that works just fine when testing, but
throws that "Missing right parenthesis error when I call it.
call isi.incuity.parse_external_key(1.1.1.1.1.1)
I am actually having this problem with all of my stored procedures

hi all, i ve been struggeling with this function and i can not see
what is the problem.
i am using it for getting the following result:
**********************************************************************************************************

SQL> select systimestamp from dual;
SYSTIMESTAMP
----------------------------------------------------------
04-Jan-08 05.40.38.275785 AM +00:00

Hi to everybody and sorry for my english
i have a problem with a query in a comparison of date
it seems that oracle fails in comparring two date in a function
this is the function:

Upgrading a database  from Oracle 9i to 10g.
I have encountered a problem with the ODBC 10.1.0.2.0 driver, it
transforms the 21 numeric digits from a PK column to a scientific
format.

Hi DB Gurus,
I have an application which tries to access data from more than one
identically structured databases. Each of the databases has the same
table with different data which the application reads and tries to

Good morning.
I have a table with a date column. I want to find the next latest date
in the data in that table.
I have got this far:

I have a database, I did level 0 backup using RAMN, let us say it took
t1 minutes.
Now I deleted lot of data in database using delete staements (as part
of some application archiving  process). I do level 0 backup again.