An interesting use of sequences might be to encrypt information.
Properly sequenced sequences could be used to easily encode
information that would be destroyed upon being read.
Know, I dunno where that came from, just hit me out of the blue
while reading this thread. Could be fun though.
Jared
"Fink, Dan" <Dan.Fink_at_mdx.com>
Sent by: root_at_fatcity.com
07/30/2002 01:31 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: Creating sequences on the DUAL table?
To be more accurate, a sequence does not even have to be used for a table.
It is a construct to populate a variable (could be a table column, could
be
run time) with a number that is generated in a specific order (though it
may
contain gaps).
Dan (as he ducks a knitting needle).
-----Original Message-----
Sent: Tuesday, July 30, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L
Cherie,
Terminology -- make sure they understand that sequences are not
created attached to any table and can be used for more than one table.
Rachel
- Cherie_Machler_at_gelco.com wrote:
>
> Dan,
>
> Haven't heard the why yet but I think it may be just a poorly worded
> request. I suspect he wants the sequences created on another table
> and
> just wants to be able to select from dual. Maybe he never realized
> that
> the sequences were actually created on another table. Maybe he
> actually
> thought that the sequences were created on the DUAL table since he
> only
> ever used them by selecting from DUAL. Our developers run quite a
> wide
> gamut and I don't work very regularly with this one so it's hard to
> know
> where he's coming from. Still trying to get him on the phone.
>
> Thanks for this info about performance on DUAL. I will pass the info
> on.
> Thanks to everyone for getting us all on the same page. I'm sure
> that
> once I talk this out with him, it'll be straightened out quickly.
>
> Cherie
>
>
>
>
> "Fink, Dan"
>
> <Dan.Fink_at_mdx. To:
> "'ORACLE-L_at_fatcity.com'" <ORACLE-L_at_fatcity.com>,
> com>
> "'Cherie_Machler_at_gelco.com'" <Cherie_Machler_at_gelco.com>
>
> cc:
>
> 07/30/02 12:46 Subject: RE: Creating
> sequences on the DUAL table?
> PM
>
>
>
>
>
>
>
>
>
> Cherie,
> My first response is 'WHY?'. Do they mean that they want
> to
> create 2
> new sequences and use the DUAL table to retrieve the values? It will
> cause
> performance problems and there are better solutions. I have some
> information
> on the performance implications of DUAL at
> http://www.optimaldba.com/internals/oraint_dual.html.
>
> Dan Fink
>
> -----Original Message-----
> Sent: Tuesday, July 30, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> I have a request from one of our developers to create two new
> sequences on
> the DUAL table.
>
> This seems like a bad idea to me. I've never had such a request in
> the
> past. I asked for clarification on why this is needed and I didn't
> get a
> lot of details yet.
>
> Is this something that is standard operating procedure? My
> understanding
> that interfacing with the DUAL table is usually inviting poor
> performance.
> Plus, I don't like to mess around with system tables, in general.
>
> Under what circumstances would it be justified to create sequences on
> the
> DUAL table? Should I just flat-out refuse this request and if so,
> why?
>
> Thanks,
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Cherie_Machler_at_gelco.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).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Cherie_Machler_at_gelco.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).
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fink, Dan
INET: Dan.Fink_at_mdx.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.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 Tue Jul 30 2002 - 18:03:26 CDT
