Re: update syntax

From: <amit.poddar_at_yale.edu>
Date: Tue, 22 Mar 2005 15:16:53 -0500
Message-ID: <1111522613.42407d35f3384@www.mail.yale.edu>

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_at_ph.com>:

>
> 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

Received on Tue Mar 22 2005 - 15:20:28 CST