RE: SELECT SKIP (Was: RE: Off Topic: Row Locking

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Wed, 14 Feb 2001 09:22:31 -0800
Message-ID: <F001.002B41E2.20010214090037@fatcity.com>

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

----------- ---------- --------- --------------


       2748     133269 05-SEP-00              3

       1669     133271 05-SEP-00              3

         85     133271 05-SEP-00              3

        342     133346 05-SEP-00              3

        384     133346 05-SEP-00              3

        390     133346 05-SEP-00              3

        395     133346 05-SEP-00              3

        676     133346 05-SEP-00              3

       2083     133346 05-SEP-00              3

        300     133347 05-SEP-00              3

        384     133347 05-SEP-00              3

        384     133347 05-SEP-00              3

        393     133347 05-SEP-00              3

        398     133347 05-SEP-00              3

       1132     133347 05-SEP-00              3

         85     133348 05-SEP-00              3

        384     133348 05-SEP-00              3

85 133412 05-SEP-00 3
479 133444 05-SEP-00 3
19 rows selected.

SQL> Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

-----Original Message-----
From: yong huang [mailto:yong321_at_yahoo.com] Sent: Wednesday, February 14, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Subject: SELECT SKIP (Was: RE: Off Topic: Row Locking - Row Id)

Hi, Riyaj,

Could you post your screen shot that shows select * from t1 skip locked? What version of Oracle are you using? Mine is 8.1.6 Enterprise Ed:

SQL> select * from test skip locked;
select * from test skip locked
*

ERROR at line 1:
ORA-00933: SQL command not properly ended

SQL> select * from test skip lock;
select * from test skip lock
*

ERROR at line 1:
ORA-00933: SQL command not properly ended

SQL> desc test
Name                                      Null?    Type
----------------------------------------- -------- --------
A                                                  NUMBER
B                                                  ROWID
D                                                  NUMBER
Yong Huang
yong321_at_yahoo.com

you wrote:

If you want to show only rows that are locked then you could use this undocumented feature: 'select * from t1 skip locked'. This will skip all the rows that have been locked.

Thanks
Riyaj "Re-yas" Shamsudeen

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: yong huang


  INET: yong321_at_yahoo.com



Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Feb 14 2001 - 11:22:31 CST

RE: SELECT SKIP (Was: RE: Off Topic: Row Locking - Row Id)