Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: this drove me crazy!!!

RE: this drove me crazy!!!

From: <Chaim.Katz_at_Completions.Bombardier.com>
Date: Mon, 12 Feb 2001 12:38:46 -0800
Message-ID: <F001.002B1E63.20010212114528@fatcity.com>

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" <BoivinP_at_mar.dfo-mpo.gc.ca> on 02/12/2001 08:55:37 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Chaim Katz/Completions/Bombardier) Received on Mon Feb 12 2001 - 14:38:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US