Re: update syntax

SQL> create table nnn (id1 number(2), id2 number(2));

Table created.

SQL> insert into nnn values (1,2);

1 row created.

SQL> commit;

Commit complete.

SQL> update nnn 
  2  set (id1,id2) = (select 1,2 from dual)
  3  where id1=1;

1 row updated.

SQL> 

Quoting Guang Mei <GMei@xxxxxx>:

> 
> On oracle 9i,
> 
> I thought I saw a similar sql looks like below, but this one does not
> seem
> to work. Anyone could tell me the correct syntax? TIA.
> 
> 
> update T1
> set    c1 , c2 = (select c1, c2 from T1  where id= 123)
> where id= 456;
> 
> 
> Guang
> 
> 
> 
> 
> 
************************************************************************
*
> 
> PRIVILEGED AND CONFIDENTIAL: 
> This communication, including attachments, is for the exclusive use
> of
> addressee and may contain proprietary, confidential and/or
> privileged
> information.  If you are not the intended recipient, any use,
> copying,
> disclosure, dissemination or distribution is strictly prohibited.  If
> you
> are not the intended recipient, please notify the sender immediately
> by
> return e-mail, delete this communication and destroy all copies.  
> 
************************************************************************
*
> --
> http://www.freelists.org/webpage/oracle-l
> 


--
http://www.freelists.org/webpage/oracle-l

Other related posts: