The following SQL works well without the last line, once I add the
last line, I get ORA-01858.
I am not sure why it works in the SELECT but not in the WHERE clause.
We have Oracle 9.2.0.7.

Basically, i was attempting to insert a data in one my table while the
oracle blowed an error saying that cannot insert data in column x
since the data type for that column is small. After that i altered the
table made the correct change and but now my question is i dont see

I have a DSS system which has been heavily tuned over the past few
years. The system is tuned as well as it likely will be tuned. But
it's heavily loaded with jobs.
We are tasked with Migrating from AIX to Windows 2003.

I am trying to get my head around who to best design a couple of
tables for performance.  The entities are fake so ignore that, I am
just focusing on the table sizes and values.
Suppose I had a table called items with 50,000 rows

I was asked how to verify what tables, privs, and such a particular
oracle user had.
Short of showing the scripts I used to create the user, how do I
actually go back in

We have an immediate requirement at one of our direct client clients
in Delray Beach, Florida.
Here are the details:
*  Minimum of 5 Years of experience working with Oracle Applications.

I try to reduce redundancy.  If you change the line with comment "--
ERROR:" to refer to the vararray's LIMIT you get ORA-00904:
LINE/COL ERROR
-------- -----------------------------------------------------------------

I have 2 tables with a master/detail relationship (delivery note
header and detail)
Now I want to do a trigger to update the stock table. In the delivery
note header table I have the warehouse and in the detail I have the

I'm looking for some pointers to documentation, etc. that will help us
understand our options (experiences/horror stories would also be useful).
I'm a sysadmin/developer and don't have a significant oracle background.
 I've been reading the Oracle Database Administrator's Guide ...

               I am using  sequence in sql-loader to insert unique
values in a table.
ctl file (Demo):
LOAD DATA

I need help on this problem:
In a form data block I want to enter in the Property WHERE CLAUSE a
clause based on certain conditions:
1. the first condition is ANA_TYPE := TXT_ANA_TYPE AND ANA_CODE :=

Hey guys,
I've an table with a column, let's call it employee_id. Do you know an
sql statement, which can check employee_id, if it has duplicate
entries ?

Does DBMS_JOB always run on creation of the job. I dont want the job
to run on creation but only during the specified interval.Is there any
way?

How can I round UP 5.1 to 6 ?
thanks

I am trying to write a text file using utl_file to write to a file.
I used
UTL_FILE.FOPEN(v_ftp_folder, v_cms_file, 'w');
UTL_FILE.PUT(v_outfile_handle, 'X');