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

Home -> Community -> Usenet -> c.d.o.misc -> Re: about dbms_job

Re: about dbms_job

From: Eitan <nospam_at_nospam_please.com>
Date: Tue, 9 May 2006 09:51:29 +0200
Message-ID: <446037a4@news.bezeqint.net>


One little problem,
 is that when I do select statement,
Oracle first update the db, and after that retrive, so if I do :
select my_updated_column, my_package.update_column(...) from dual;

I get on the result of that query :
my_updated_column is the result after the column is updated. first : update the column
second : retrive the column

What if I want to do :
first : retrive the column,
second : update the column.

Thanks :) Received on Tue May 09 2006 - 02:51:29 CDT

Original text of this message

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