(8.0.22)
drop function func1;
delimiter //
create function func1()
returns int
deterministic
begin
return 0;
end//
delimiter ;
show create function func1\G
drop procedure proc1;
delimiter //
create procedure proc1()
begin
select 1;
end//
delimiter ;
show create procedure proc1\G
create or replace view view1 as select * from tab1;
show create view view1\G
(19c)
create or replace function func1 return integer as
ret integer;
begin
return 0;
exception when others then
raise;
end;
/
select text from dba_source
where owner = 'TEST'
and name = 'FUNC1'
order by owner,name,line;
create or replace procedure proc1 as
begin
return;
exception when others then
raise;
end;
/
select text from dba_source
where owner = 'TEST'
and name = 'PROC1'
order by owner,name,line;
create or replace view view1 as select * from tab1;
select text from dba_views
where owner = 'TEST'
and view_name = 'VIEW1'
order by owner,view_name;
(13)
create or replace function func1()
returns integer as $$
begin
return 0;
end;
$$ language plpgsql;
\df+
select prosrc from pg_proc
where proname = 'func1'
;
create or replace procedure proc1()
language plpgsql
as $$
begin
return;
end;
$$;
\df+
select prosrc from pg_proc
where proname = 'proc1'
;
create or replace view view1 as select * from tab1;
select definition from pg_views
where viewname = 'view1'
;
(2019)
https://sql55.com/query/list-all-user-defined-functions.php
create or alter function func1()
returns int
as
begin
return 0
end
select definition from sys.sql_modules
where object_id = object_id('func1')
;
create or alter procedure proc1
as
begin
return;
end
select definition from sys.sql_modules
where object_id = object_id('proc1')
;
create or alter view view1 as select * from tab1;
select definition from sys.sql_modules
where object_id = object_id('view1')
;