All, some Friday afternoon frustration. I have created a script to
demonstrate a problem I am currently having and have included it inline
below. Despite the clear error message "ORA-00942: table or view does
not exist ", I don't understand why it is occurring. Account.orgs is a

I have an Oracle user with lots of tables, and want to create another
user that can see all of the first user's tables, but not modify any
data. It's easy to do this by creating a grant for each table, like
this (as user1):

Hi,all
When I login to oracle database, a strange problem occurs, here comes the
details:
Platform: Solaris8

I have a .csv dump routine (code at end of post) and it's not working.
When I try to run as SYS this line
DUMP_CSV('select * from scott.emp', ';', 'D:\Paul', 'billy.csv');
SQLPlus returns.

Hi folks, got a problem with the "logmeoff" function of mod_plsql
You can, if you prefer, simply jmp to the QUESTION at then end.
We are using basic authentication and the user has to enter an Oracle
username/password to access the app.

Is there anyway to select a clob with the refcursor? Let me explain.
mytable =
id | name | addressCLOB = type clob
-----------------------

Sir,
Please any one can help me about this error.I have gone through internet but
i couldn't get solution for this
error.Actually i am calling a sql procedure in c++  and i am getting this

  I am trying to generate a flat file with the following layout from
an Oracle table:
  Column       Start     End      Length
 --------     -------   -----    --------

All,
first I'd like to verify that my understanding of Oracle's concept of
timestamp data types is correct:
SQL Standard has data types DATE (date only), TIME (time only) and

I'm new to Oracle and I just set up an Oracle 9i Database on a WinXP
Prof. System. The first one Database is now running pretty fine but now
the Problem is, I need a second one. So I created a new Database and a
new Listener. 1st Problem is, the Listener fails to start (ORA-12541:

How to immediately terminate a transaction? (I just come across 'alter
system kill session' but it doesnt immediate kill any running transaction of
the session)

In Oracle, writer never blocks reader.  That's fine.  But, does that
means I can always assume a read will successful - absolutely no other
factors could really block a read?

I'm translated SQL Server stored procedures into Oracle. We used
sp_executesql before and I'm trying to use Execute Immediate to mimic
the previous code. Here's my problem:
The schema name is passed into the stored procedure. We concatenate the

If I have a table that is defined as:
CREATE TABLE ORGS
(
NUM    INTEGER    NOT NULL,

We have purchased licenses for Oracle 10g.  We have per CPU licensing
on Production, and per user licensing on Test.  My understanding is
that Development licenses are free.
Does SQL*Plus or SQL*Plus Worksheet require additional licensing?  Or