update my_table
set col1 = 45,
col2 = 43
where .
>>> [EMAIL PROTECTED] 03/29/01 06:50PM >>>
Hi!
Can I update two columns in a single update statement? What is the exact
syntax for this...
update tablename set col1,col2 = 45,33
Just like in an insert statement, yo
March 29, 2001 5:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Update two columns in a single update statement
>
> Hi!
>
> Can I update two columns in a single update statement? What is the exact
> syntax for this...
>
> update tablename set col1,col2
On 29 Mar 2001, at 15:50, Helmut Daiminger wrote:
> Can I update two columns in a single update statement? What is the exact
> syntax for this...
>
> update tablename set col1,col2 = 45,33
update
tablename
set
col1 = 45,
col2 = 33;
rem (for testin
RTFM (SQL Reference)
update tablename set col1 = 45, col2 = 33 where ...
-Original Message-
Sent: Thursday, March 29, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L
Hi!
Can I update two columns in a single update statement? What is the exact
syntax for this...
update
Helmut,
Try
update tablename set column1 = value1, column2 = value2 where rownum < 1
Scott Crabtree
-Original Message-
Sent: Thursday, March 29, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L
Hi!
Can I update two columns in a single update statement? What is the ex
Hi!
Can I update two columns in a single update statement? What is the exact
syntax for this...
update tablename set col1,col2 = 45,33
Just like in an insert statement, you would go
insert into (col1,col2) values (45,33)
This is 8.1.6 on Win2k.
Thanks,
Helmut
--
Please see the