Oracle-L: Re: SEQ#, DUAL and Oracle literacy

From: Thomas Day <tday6_at_csc.com>
Date: Wed, 19 Jun 2002 06:28:24 -0800
Message-ID: <F001.00481188.20020619062824@fatcity.com>

Kids, this is a trained professional. Don't try this at home.

                                                                                           
                    Alexandre                                                              
                    Gorbatchev           To:     Multiple recipients of list ORACLE-L      
                    <alexandre.go        <ORACLE-L_at_fatcity.com>                            
                    rbatchev             cc:                                               
                    @avermann.de>        Subject:     Re: SEQ#, DUAL and Oracle literacy   
                    Sent by: root                                                          
                                                                                           
                                                                                           
                    06/19/2002                                                             
                    05:13 AM                                                               
                    Please                                                                 
                    respond to                                                             
                    ORACLE-L

Don't see any problems :-)

CREATE TABLE SYS.SUPER_DUAL (specific_seq_num NUMBER(10));

DROP PUBLIC SYNONYM DUAL; CREATE PUBLIC SYNONYM DUAL FOR SYS.SUPER_DUAL; INSERT INTO SYS.SUPER_DUAL VALUES(666); Vua-la!!! ;)

--
Alexandre



> Want to have a good laugh?... read on... I don't  think its OT :)

>

> A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle

> Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the

> application will get a *specific* Sequence Number for something.

>

> DBA: Why do you think DUAL is the problem?

> Duhveloper:  ...'cause I see the PL/SQL code that says 'from dual'.

>

> Boy! Are we in trouble or what??   ;)

>

> - Kirti


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
  INET: alexandre.gorbatchev_at_avermann.de

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: Thomas Day
  INET: tday6_at_csc.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 Jun 19 2002 - 09:28:24 CDT