<%@ page language="PL/SQL" %>
<%@ plsql procedure="show_parts" %>
<%@ plsql parameter="minprice" type="NUMBER" default="100" %>
<%! color varchar2(7); %>
Show Parts
Part Listing with different colored display for parts
greater than <%= minprice %>.
| PNO |
Part Name |
Price |
<%
for p in (select * from parts order by price desc) loop
if p.price > minprice then
color := '#CCFFFF';
else
color := '#CCCCCC';
end if;
%>
| <%= p.pno %> |
<%= p.pname %> |
<%= p.price %> |
<% end loop; %>