似水流年

create or replace procedure Test1(score in number)asbegin  if(score>90) then   begin   dbms_output.put_line('the result is A');   end;   elsif(score>80) then    begin   dbms_output.put_lin...

create or replace procedure Test1(numbera number)astestresult number(4);begintestresult:=0;for tempa in 0..numbera loop begin testresult:=testresult+tempa; end;end loop;dbms_output.put_line('the resul...

create or replace procedure Test1asstrresult varchar2(20);cursor cursor1 is select empno from emp; beginstrresult:='empno is ';for everyrow in cursor1 loop begin  strresult:=everyrow.empno; dbms_outpu...