| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sql query
You need to put the scalar subquery inside parentheses:
Update PIPPO set FIELD =
DECODE(FIELD1,'AA', DECODE(
(SELECT COUNT (DISTINCT FIELD1) FROM
TAB
WHERE ANNO = '2003') , '1' ,'100', '90'), '100')
WHERE ANNO = '2003'
-- Posted via http://dbforums.comReceived on Tue May 13 2003 - 06:21:50 CDT
 |
 |