A Nashville client has an immediate requirement for an Oracle PL/SQL
Developer for a 6 month Contract-to-Hire position.  The Developer will
be the principal PL/SQL developer on a team charged with rebuilding a
high transaction volume Billing & Collections system for hundred's of

I have a CLOB column containing delimited data file.
I need to parse this data and load it into a regular table.
The line size is variable.
The entire operation has to be within the database, I cannot talk to

I used to have a "service request" tab on Metalink. It's no longer there
and there is no other way to list all of your SR's. You can only search
for an SR# with "quick find" if you already know the number.
I'm trying to find the metalink document that says that regardless of

I need to create an optimized table in my production database...
I have  a sql script that make several insertions into database based
in user id.
insert into tablea (user ,value , date , ..{many values}...plan ,

I could have sworn when I was walking out of the Moscone South there was
a big sign saying "see you next year" with the dates Sept 11-15. However
talking to someone on the shuttle back to the airport friday they said
they read somewhere that next years event is going to be in ...

Oracle 9.2.05 on hp unix 64bit  no clusters no rac
To make sure backups are good they database files are saved to a server
,opened readonly shut down and then  backed   up to tape.
Bcv sync / split  are done to get the backups

Oracle 9.2 STANDARD Edition on Solaris 5.9
On Friday (Oct 27) I brought up a new database, quickly configured rman
and took an incremental 0 backup.  Today (Oct 30) I began putting
together scripts to handle all of the backup requirements -- weekly

righty, after a bit of investigation I found a solution.
I have take tom kytes code from here:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:139812348065
and converted it to vb .net using the corelab Oracle driver. Probably

I understand that Oracle 10g will rewrite your CURSOR FOR LOOP
statements into a BULK COLLECT statement.
I am contemplating no longer explicitly writing the BULK COLLECT from
now on as it reduces the number of lines of code and greatly simplifies

I want to list all the stored procedures that are being used, when, how
many times, who uses etc(kind of monitoring/auditing). All of these
stored packages are declared in packages.
Does anyone knows how to do it??

I have a table where I am searching for text in a long field to be
replaced in Oracle 8.
I have created something like
update table_tbl

Is is possible to recover deleted rows from a table, from archive logs?
For example, say you have a database with archive logging turned off.
You create a table and populate it with records. You then reset the logs
and place the database in archivelog mode.

I'm having an issue with an outer join query that I'm hoping someone
can help me with.  I have 3 tables; Emps, Quals, and an XRef table.  I
want to be able to see, for a given set of employees, what quals they
have, and what quals they do not have.  I want this to be returned to

Hey guys,
 I thought I try to get some help in trying to get this problem
resolved.
 I've struggled with the 'Checkpoint not complete' error message

Oracle 9i Standard Edition
Red Hat Linux 5
I'd appreciate any help on the following senario and how to divide up
Oracle mem.