RE: this drove me crazy!!!

I am wondering why your customer would want to select where an insert is taking place. It doesn't make much sense.

Are you sure the customer didn't mean: "I can put a SELECT statements inside the WHERE clause of an INSERT statement"?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>

        -----Original Message-----
        From:   Abdul Aleem [SMTP:abchaudhary-ho_at_beaconhouse.edu.pk]
        Sent:   Monday, February 12, 2001 8:42 AM
        To:     Multiple recipients of list ORACLE-L
        Subject:        RE: this drove me crazy!!!

        Yes! he can, as a matter of fact he can even write a complete song
in WHERE
        clause, its just that it won't work :)
        HTH!
         -----Original Message-----
        Sent:   Sunday, February 11, 2001 1:25 AM
        To:     Multiple recipients of list ORACLE-L
        Subject:        Re: this drove me crazy!!!

        I think your customer is just testing your treshold for insanity

        ORACLE-L_at_fatcity.com wrote:


        >

        > Hi d.b.a people,

        > how r u?

        > I'm an Oracle DBA and my customer told me something that drove

        > me crazy,he told me that he could write an 'insert statement' in

the


        > 'where' clause of a 'select' statement.

        > Is this true? and if so,could you kindly tell me how?

        > thanks alot

        > 

        >

____________________________________________________________________


        > Get free email and a permanent address at

http://www.netaddress.com/?N=1


        > -- 

        > Please see the official ORACLE-L FAQ: http://www.orafaq.com

        > -- 

        > Author: MOHAMMAD AMER

        >   INET: mohammad_amer_at_usa.net

        > 

        > 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).
        __________________________________________________________________
        Get your own FREE, personal Netscape Webmail account today at
        http://webmail.netscape.com/
        -- 
        Please see the official ORACLE-L FAQ: http://www.orafaq.com
        -- 
        Author: 
          INET: bmarialuz_at_netscape.net

        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: Abdul Aleem
          INET: abchaudhary-ho_at_beaconhouse.edu.pk

        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: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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).