有一个存储过程
create or replace procedure show_time
as
the_title varchar2(30) := 'what time is it on the server?';
the_time varchar2(20) := to_char(sysdate,'dd-mm-yyyy');
html varchar2(200);
begin
html:= '<html><head><title>'
|| the_title
|| '</title></head><body>';
html := html || 'it is now:' || the_time;
html := html || '</body></html>';
htp.print(html);
end;
创建之后,如何在浏览器中执行?
浏览器中应该输入怎么样的地址?
create or replace procedure show_time
as
the_title varchar2(30) := 'what time is it on the server?';
the_time varchar2(20) := to_char(sysdate,'dd-mm-yyyy');
html varchar2(200);
begin
html:= '<html><head><title>'
|| the_title
|| '</title></head><body>';
html := html || 'it is now:' || the_time;
html := html || '</body></html>';
htp.print(html);
end;
创建之后,如何在浏览器中执行?
浏览器中应该输入怎么样的地址?
还是web企业管理器?