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

2001-02-14 Thread Steve Adams 

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 ORACLE-L


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
[EMAIL PROTECTED]

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

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

2001-02-14 Thread Koivu, Lisa 
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:[EMAIL PROTECTED]]
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
[EMAIL PROTECTED]


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: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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).