From lkoivu@qode.com Wed, 14 Feb 2001 09:22:31 -0800 From: "Koivu, Lisa" Date: Wed, 14 Feb 2001 09:22:31 -0800 Subject: RE: SELECT SKIP (Was: RE: Off Topic: Row Locking - Row Id) Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 ----------- ---------- --------- --------------        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@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@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@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@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).