Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Running functions in Oracle
I have a simple function
create or replcae function show_date return number
is
begin
select * from table;
return 1;
end;
I need to display all the contents of the table into the screen, one
screenful at a time.
How do I execute functions from sql? I have this saved in a file, and
I did get the function to compile. How do I get this to display on
the screen?
Any help would be appreciated.
Thanks
Vinay
gidwani_at_studsys.mscs.mu.edu Received on Thu Jul 24 1997 - 00:00:00 CDT