I was wondering why people put "+ 0" after a column when creating view.
For example,
CREATE OR REPLACE FORCE VIEW APPS.PER_ADDRESSES_V (a, b, c) as
select a,

I had some code in the package body but when taking it out I still
encounter the error:
Compilation errors for PACKAGE SIEBEL.IF_DVA_INBOUND
Error: PLS-00103: Encountered the symbol "CREATE"

The only way I can think of to do this is to create a cursor and
somehow loop through the rows, comparing each column, and sum the
totals.  Does anyone know a more straightforward, easier way to
accomplish?

Say I have an associative array 'blah' and it has members 'hello' and
'bye.'
How can I instruct Oracle to return a NULL if I lookup the array and
the value isn't found?

I am trying to insert a record into a table.  The text that was given
to me includes the following piece:
'IRIS,IP&OP SLOT,'
Oracle (TOAD specifically) errors on this ... how do I insert the &

Ever had one of those days?
I simple merge script, to take data from a temp table, and load it into a
live table.  Sounds easy, right?
Well, the error comes back as:

I have used Perl for a long time, and it is the only language I use to
do Windows command scripting.   I have always used the Perl version
from Activstate.com.  Now that Oracle is delivered with a version of
Perl, I am running into compatibility problems.

Does anyone know of any built-in PL/SQL functions that will take a
table like this:
ID     DATA
1      A

I want to know how to use Oracle views with session variables in
Access.
The parameterised views in access, are migrated to views with per
session

I have a table that contains 3 columns,
CIDUSER
CTIMESTAMP
CSUBJECT

I use pro*c of Oracle 8.1.7 on HPUX.
I have a program (not written by myself) that executes a SELECT in a
function sequence like this:
       EXEC SQL CONNECT ... IDENTIFIED BY ... AT ... USING ...;

Does anyone know how to generate a histogram generation script for a
given set of tables?
I need to do this as I will be rebulding stats on an 8i database & want
to create the histograms afterwards

Hello.  To dump a redo logfile online or offline, you do this:
alter system dump logfile 'filename'
This places a dump the the udump directory.
How to I alter this command so that I can specify a filepath to place

Am trying to learn Oracle at home (between jobs!).
Log on as scott/tiger.
set linesize 10000
set pause on

Hi everyone, I have a question about UTL_FILE that is
driving me crazy - I just cannot get it to see the
file.
Firstly the details: