| 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 -> Sql query
Update PIPPO set FIELD =
DECODE(FIELD1,'AA', DECODE(
SELECT COUNT (DISTINCT FIELD1) FROM
TAB
WHERE ANNO = '2003' , '1' ,'100', '90'), '100')
WHERE ANNO = '2003'
Where is the error ?
Thanx
-- Posted via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Tue May 13 2003 - 03:50:00 CDT
 |
 |