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 ...;

Hello...
Oracle 8.1.7 on Win2k-Serv SP2 P3-1.2 1GB RAM. Lots of freespace on all
partitions.
This database has been working flawlessly for several years. Recently I had to

A colleague of college has send me the questions of the 1Z0-040
(Oracle Database 10g: New Features for Administrators) exam proposed by
TestKing (v1.0) -It's a nice compilation of questions about referred
exam.. Unfortunately I don't have the answers. Could somebody send me

Dear Experts,
I hate to have to post such a seemingly dumb question.
But all the obvious has not worked.
My new XP Pro laptop was recently configured for me.

I am trying to use the dba_dependencies view to create a hierarchical
indented tree list of where objects are used. But the rows in
dba_dependencies seem to overstate the actual direct references. For
example, if I have the following:

I write for a problem inserting data.
The 2° CURSOR SelezionaCampi (v_NumeroCommessa varchar2, v_ProgRiga
varchar2, v_ProgRigaFattura varchar2, v_Mese Number)
insert NULL values into my Table fields?

I got a database on Solaris 10 that is still 8.1.5. I need to upgrade
to 10g.  Since there is no direct way from 8.1.5 to 10g, I had to
upgrade from 8.1.5 to 9.0.2 and then migrate to 10g from 9.0.2.
I downloaded 9.0.2 from Oracle and runs the installer with auto

I need to replace a decode statement with some other process.
currently the old DBA's code reads:
sum(decode(status 'PENDING', 1, 0)) PENDING
We added several new "PENDING" entries.  I need to rewrite it as:

Hi, can someone help me, please?
I have a big table with two different fields f1 and f2, there are many
many different combinations of these two fields values.
Now I need to do this:

Can anyone say a few words to a beginner on how Oracle server knows
when a program or OS has crashed, so that it can free a resource for
someone else?
The simple example I have is in SQLPlus spreadsheet, if I insert a

A big hello to all readers here! I have been searching all the way
into this newsgroup to find a solution to my problem, but it seems
that no one has ever had it! Let's make it simple.
I have my server on a webfarm LAN, its ip address is: 192.168.0.1

I would like to see if there is a simple way to have 2 sqlnet.ora files on a
client. Need to have 2 different configurations for ASO and can't figure out
out ot best do it. My problme is that from the same client, I need to be
able to enable encryption on ASO-enabled instances and ...

I am using sqlldr to perform bulk insertion, however, I would like to config
that whatever there is a reject/bad record found, the whole insertion will
be rollback (all or none). Could anyone here can help me through how to
setup? thanks!!

I run a query using either outer join and inner join. But outer join is
much faster even I know inner join is enough.
Thanks for any explanations.

I have recently installed Tora and I tried to debug a PL/SQL package I have
installed on my schema. During debugging, Tora gets PLS-905 error.
Suspicious, I
have run the same query through sqlplus. I got the same error.