ازى اطبق هذا الكود فى pl/sql

select sum(DESVALUE),ssn

from DESEMP
group by ssn

;


انا لما انفذه فى pl/sql
يعطى خطا على group by

DECLARE

a NUMBER;

b NUMBER;

BEGIN

SELECT e,f INTO a,b FROM T1 WHERE e>1;

INSERT INTO T1 VALUES(b,a);

END;

example:/..http://infolab.stanford.edu/~ullman/fcdb/oracle/or-plsql.html////