I'm getting an "ORA-00932: inconsistent datatypes: expected - got -"
message with the pl/sql code at the bottom. This is just an over
simplication of the original query that was generating the message.
Turns out that when "test_view" is used twice in the query, the oracle

create procedure tab_rows
               IS
               tab_name varchar(50);
               declare cursor all_tabs is

Suppose:
-  you have a table that has only a few colums and one of them, an
integer column, is used as an index;
-  rows in this table are only ever selected using the index field;

I have a problem with the output of my query in Sql*Plus. Hopin for an
answer...
My output looks like:
ID_XXXX SUM(XXXXXXXXXXXXXX)

Hi, I'm an Oracle Newbie having some issues with Recovering a Database
and testing Oracle Disaster Recovery Procedures.
I've backed up the database using RMAN and have set configured it to
use the Controlfile and AUTOBACKUP option....the backup procedure works

  I have been working with a group who has a web application that queries a
4 field table.  One field data type is a long.  The attachments contain
multiple screenshots and other misc. data for SOX requirements.  I have been
told that the record can have up to 100 Meg of data ...

http://www.computerworld.com/databasetopics/data/software/story/0,10801,110521,0
0.html
wrote:
APRIL 17, 2006 (COMPUTERWORLD) - Oracle Corp. appears to have
accidentally released details about an unpatched security vulnerability

I need to install oracle on a number of unix platforms
I need some pre-install scripts. Send me one?

I have a machine server (win 2000 pro) on which are installed Oracle 9i
server and IIS server; on IIS there is a web application, written in
ASP, that use the Oracle db. ASP runs server side, so I think that
clients accessing the application through their browsers, does not need

I'm building datawarehouse using classical star schema. I have
dimension called sellto_dim and second dimension called shipto_dim
which is identical as sellto_dim. My idea is to create only view based
on sellto_table instead of creating second physical table. The question

I know this topic must have been beaten to death but I am new to OCI
and Oracle.
I am converting programs using Sybase DBLIB to Oracle and need to know
how to

We have been having problems with data that contains single quotes (as
an apostrophe) in text fields (for example a name field or a notes
field). This causes problems when we attempt to create SQL statements
from our application, since the quote appears as a string-creating

I recently discovered that, along with the old RENAME command, that can
be used to RENAME a table (and some other database object type too) we
can now use the command ALTER TABLE <table_name> RENAME TO <new_name>;
The first improve of this new syntax is that we can now, logged with ...

why the oracle DB autonumber Sequince miss some numbers...for example
11265
11285
11305

I've just started with Oracle and I got a problem...
is it possible to call an external program (or maybe COM object on
windows platform) within a trigger ?
Ideally what I'd like to do is to perform RPC call or a program call