<%@ page language="PL/SQL" %> <%@ plsql procedure="show_detail" %> <%@ plsql parameter="p_Cust_ID" default="0"%> Detail-Datasets: Orders of Customer
<% for item in (Select Order_ID, Order_Number, Order_Sign, Stat_ID, Stat_Desc, Prod_Name, Prod_Price FROM CustOrders, Status, Products WHERE ORDER_CUST_ID=p_Cust_ID AND Stat_ID (+)=Order_Status AND Order_Prod_ID=Prod_ID ORDER BY Order_Cust_ID ) loop %> <% end loop; %>
Bestellnummer Artikelname Preis Anzahl Bestellbezeichnung Bestellstatus
<%= item.ORDER_ID %> <%= item.Prod_Name %> <%= item.Prod_Price %> <%= item.Order_Number %> <%= item.Order_Sign %>