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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 11g new features

Re: Oracle 11g new features

From: William Robertson <williamr2019_at_googlemail.com>
Date: 25 Mar 2007 15:00:21 -0700
Message-ID: <1174860021.222608.13340@d57g2000hsg.googlegroups.com> 





On Mar 25, 10:22 pm, "Fuzzy" <fuzzy.greybe..._at_gmail.com> wrote:


> UPDATE table

> SET col=value ...

> SET_IF_CHANGED col=value ...

>

> which (amongst other things) would not invoke triggers when the

> new=old.




Nice idea - that would make this existing PL/SQL syntax useful:
UPDATE table SET ROW = plsql_record


and that would be a start in fixing FORALL.
Received on Sun Mar 25 2007 - 17:00:21 CDT












Original text of this message













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