Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
set serveroutput on
set echo off
set pagesize 0
set trimspool on
set feedback off
spool c:\yada.html
select 'This is sample output from Oracle that I can view from my web browser.' from dual
/
spool off
prompt
prompt Now, enter "C:\yada.html" in your web browser's URL/address field and press [Enter]
prompt
DECLARE
l_file utl_file.file_type := utl_file.fopen('your_directory_path','yada.html','W');
BEGIN
utl_file.put_line(l_file, '<HTML><HEAD><TITLE>This Is My Drop List</TITLE></HEAD>
<BODY><H2>Here Is My Test Drop List</H2><HR>
utl_file.put_line(l_file,'<FORM METHOD=POST ACTION="YOUR URL CALL HERE GOES HERE">');
utl_file.put_line(l_file,'<B>YOUR PROMPT GOES HERE: <SELECT NAME="your_variable_name">');
FOR i IN (SELECT the_value, the_meaning FROM my_table) LOOP
utl_file.put_line(l_file,'<option VALUE="'||i.l_value||'">'||i.the_meaning);
END LOOP;
utl_file.put_line(l_file,'</SELECT></B><P>
<INPUT TYPE="submit" VALUE="LABEL FOR YOUR SUBMIT BUTTON">
<INPUT TYPE="reset" VALUE="LABEL FOR YOUR CLEAR FORM BUTTON"></BODY></HTML>');
utl_file.fclose(l_file);
END;
FOR i IN (SELECT DISTINCT the_value, the_meaning FROM my_table) LOOP