test

CREATE OR REPLACE PROCEDURE sie_linhusong
AS
BEGIN
dbms_output.put_line('hello');
END;

create or replace procedure HelloWorld IS
acount NUMBER;
CURSOR mycc IS SELECT ssex,ssgrade, COUNT(*) AS ccc FROM test_test_test GROUP BY (ssex,ssgrade);
/*temp_line mycc%ROWTYPE;*/
BEGIN
FOR temp_line IN mycc LOOP
IF temp_line.ssex='1' AND temp_line.ssgrade='86' THEN
acount:=temp_line.ccc;
dbms_output.put_line(acount);
END IF;
END LOOP;
end;

SELECT ssex,ssgrade, COUNT(*) FROM test_test_test GROUP BY (ssex,ssgrade)

SELECT  COUNT(*)  FROM test_test_test  WHERE ssex='1' AND ssgrade='86' GROUP BY (ssex,ssgrade);