how to run procedure and function
create or replace function myfun return varchar2 is
begin
return 'helo bhai';
end;
/
select myfun from dual;
describe dual;
execute myfun;
select myfun('hello world') from dual;
CREATE OR REPLACE FUNCTION MYFUN2(VAR VARCHAR2) RETURN VARCHAR2 AS
BEGIN
RETURN VAR;
END;
/
SELECT * FROM DUAL;
begin
return 'helo bhai';
end;
/
select myfun from dual;
describe dual;
execute myfun;
select myfun('hello world') from dual;
CREATE OR REPLACE FUNCTION MYFUN2(VAR VARCHAR2) RETURN VARCHAR2 AS
BEGIN
RETURN VAR;
END;
/
SELECT * FROM DUAL;
Comments
Post a Comment