create function jiecheng1
return pls_integer
as
i pls_integer :=1;
j pls_integer :=1;
begin
for j in 1..6
loop
i:=i*2;
end loop;
dbms_output.put_line(i);
end;
return pls_integer
as
i pls_integer :=1;
j pls_integer :=1;
begin
for j in 1..6
loop
i:=i*2;
end loop;
dbms_output.put_line(i);
end;
CREATE OR REPLACE function jiecheng1
return pls_integer
as
i pls_integer :=1;
j pls_integer :=1;
begin
for j in 1..6
loop
i:=i*2;
end loop;
--dbms_output.put_line(i);
return i;
end;
/
SQL> select power(2,6) from dual;POWER(2,6)
----------
64已用时间: 00: 00: 00.00
如果楼主是想学习写函数的话,参考这个
CREATE OR REPLACE function JIECHENG1
RETURN NUMBER is
i number :=1;
j number :=1;
BEGIN
for j in 1..6 loop
i:=i*2;
end loop;
return i;
END jiecheng1;
执行:
SQL> SELECT JIECHENG1 FROM DUAL; JIECHENG1
----------
64已用时间: 00: 00: 00.20