On Wed, 14 Feb 2001, Rachel Carmichael wrote:
Oh Jared, no.. Hitchhiker is way different (although also a Britcom)
Red Dwarf is total insanity... and it is on my PBS station on Friday nights
:)
Totally different, but the same insane wacky British humor. :)
Jared
--
Please see the
And a 1000 for Rachel as well!
Jared
On Wed, 14 Feb 2001, Rachel Carmichael wrote:
British Comedy Red Dwarf
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
Title: RE: Off Topic: Row Locking - Row Id
No, please 100 for Ms. Carmichael!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Off Topic: Row Locking - Row Id
Locke@i-CommeTo: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
rce Services"cc:
Johan.Locke Subject: RE: Off Topic: Row
Locking - Row Id
Sent by:
Title: RE: SELECT SKIP (Was: RE: Off Topic: Row Locking - Row Id)
Isn't this what you are referring to?
If you are not going to update the records, why lock them?
SQL select * from testcat for update nowait;
CATEGORY_ID PRODUCT_ID LAST_MOD_ DATA_SOURCE_ID
-- run this part from session A:
drop table lock_test;
create table lock_test ( name varchar2(10) not null );
insert into lock_test values ( 'nebula');
insert into lock_test values ( 'quasar');
insert into lock_test values ( 'pulsar');
insert into lock_test values ( 'red dwarf');
Hi Yong,
That has to be FOR UPDATE SKIP LOCKED.
There is some stuff about it on the Ixora web site.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Thursday, 15 February 2001 2:31
To: Multiple recipients of list
[EMAIL PROTECTED] wrote:
-- run this part from session A:
drop table lock_test;
create table lock_test ( name varchar2(10) not null );
insert into lock_test values ( 'nebula');
insert into lock_test values ( 'quasar');
insert into lock_test values ( 'pulsar');
insert into
Quite a few don't get it apparently.
It's a British SciFi comedy. Think 'Hithhikers Guide
to the Galaxy'.
Jared
On Wed, 14 Feb 2001, Paul Baumgartel wrote:
Now can you enlighten the rest of us? Or am I the only one who doesn't get
it?
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
Oh Jared, no.. Hitchhiker is way different (although also a Britcom)
Red Dwarf is total insanity... and it is on my PBS station on Friday nights
:)
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Off Topic: Row
rce Services"cc:
Johan.Locke Subject: RE: Off Topic: Row Locking - Row
Id
Depending on your application design, you may find a locking
scheme useful. Below is an example that uses rowid to take
out a lock. Note that this is not a lock on an object, but
simply a lock identified by a rowid.
As the demo is setup, the locks are automatically released
on rollback or
Hi Jared
Thanx for the reply.
I'll do some stress testing, and keep you up to date.
(I'm not too optimistic though)
Cheers
JL
-Original Message-
Sent: Tuesday, February 13, 2001 6:21 PM
To: Multiple recipients of list ORACLE-L
Depending on your application design, you may find a
hi,
you can simply include the hidden(or embedded) column in your querry as u
write other columns.
this is the column which is locked in every table. and can give u the
desired value for each row..
try
select col1, col2,., rowid from tablename;
saurabh
- Original Message -
To:
Hi
You could get the following columns from the v$session table and then
use dbms_rowid.rowid_create to construct the rowid:
ROW_WAIT_OBJ#NUMBER
ROW_WAIT_FILE# NUMBER
ROW_WAIT_BLOCK# NUMBER
ROW_WAIT_ROW#
Hi
Not realy what I was looking for. Thanks anyways
Regards
JL
-Original Message-
Sent: Monday, February 12, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L
hi,
you can simply include the hidden(or embedded) column in your querry as u
write other columns.
this is the column
16 matches
Mail list logo