SQL or PLSQL

From: Gary <plums_at_bigfoot.com>
Date: Thu, 2 Dec 1999 10:07:08 -0000
Message-ID: <825gel$o1u$1@pheidippides.axion.bt.co.uk>

Hi,

I recall being told that using one of either SQL or PLSQL was preferable to the other, when doing simple selects, updates or deletes from tables, however I cant remember which.
They also mentioned about context switches and the effect of performance this can have.

So, if I wanted to select some rows or delete some rows from a table, and I was using a package or stored procedure, would it be better to user a Sql statement, or a plsql cursor to do that job.

Or am I completely off the mark and getting myself unnecessarily confused here ??

Thanks Received on Thu Dec 02 1999 - 04:07:08 CST