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);