I can do it. SQL> create or replace function dumb 2 return number is 3 pragma autonomous_transaction; 4 begin 5 insert into emp (empno) values (10); 6 commit; 7 return 0; 8 end; 9 / Function created. Try a few of these: SQL> select empno 2 from emp 3 where dumb=0 and 4 empno < 20; "Boivin, Patrice J" <[EMAIL PROTECTED]> on 02/12/2001 08:55:37 AM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: Chaim Katz/Completions/Bombardier)
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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Abdul Aleem [SMTP:[EMAIL PROTECTED]] 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 [EMAIL PROTECTED] 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: [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). __________________________________________________________________ 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: [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: Abdul Aleem 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: Boivin, Patrice J 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).
