Re: Access frontal interface for Oracle database

On Mon, 11 Aug 2008 05:52:43 GMT, "gym dot scuba dot kennedy at gmail" <kennedyii_at_verizon.net> wrote:

>I was trying to use a stored procedure (so, an UPDATE query) in order to
>copy the data to a temporary table, so that the user does not lock the
>table, but opens a copy instead. I this conception erroneous ?

UPDATE has nothing to do with stored procedures Also readers don't block writers, so the temporary table is redundant. If you follow this concept, the application will be very unstable and buggy.

Finally humans happen to read from top to bottom. Only the species infested with the Mickeysoft virus can't be bothered to acknowledge that.

-- 
Sybrand Bakker
Senior Oracle DBA