I was just wondering...
Specifically, on the DELETE's WHERE clause, isn't it better to use ROWID
versus CREATED??
If you use ROWID then you don't have to walk the index. DELETE FROM tbl
WHERE ROWID.....
If you use CREATED then you have to walk the index, again? Right? DELETE
FROM tbl WHERE created....
To head off emails, I know your supposed to be very careful when working
with ROWID, i.e. not storing rowid for future reference, etc. But this
specific example seems to be ok.
Thoughts?
-----Original Message-----
Sent: Tuesday, July 09, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
delete from tbl
where rowid in (
select rowid
from tbl
where user_id = &user
and rownum =1
order by date asc
)
-bp
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 09, 2002 9:59 AM
> Hi,
>
> Can anyone help me with this delete statement?
>
> I have the following table:
>
> Name Null? Type
> ----------------------------------------- -------- -------------
> USER_ID NOT NULL NUMBER(15)
> PASSWORD VARCHAR2(30)
> CREATED DATE
>
> What I need to do is delete the oldest record for a particular user_id.
> And its doing my head in. Any help appreciated!
>
> Thanks,
> Steve.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steven Hovington
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: BigP
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
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).
