Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Back End/Paradox Front End - Record Locking Question
Hi!
Your question is quite brief, and I don't know your front end tool, but look up:
SELECT col1, col2...
FROM table
WHERE something
FOR UPDATE [NOWAIT]
or
UPDATE ...
SET ...
WHERE
There is a lot to this, look in manual on e.g:
"Oracle8i Concepts Data Concurrency and Consistency"
and boot yourself up from there.
Frank Received on Sun Aug 19 2001 - 04:02:37 CDT