Hi, I am trying to work out exactly what a cursor is .. is it sort of like, a little helper-guy who goes and gets things for you, one field at a time? or one record at a time?
Do I have to give him a name, "helpCursor" like an object, tell him to go find a field(or record?) and write something like
while(fileAccessed.hasMoreFiles)
{
System.out.println(helpCursor.currentValue);
}
i am not using
java with oracle at the moment, i am just writing javanese pseudo code because that is all i know at the moment. )-]
what i am trying to do is use an implicit cursor to display customer info of Mary Smith
from CUSTOMER
and two nested explicit cursors to display the order information...
the first cursor gets
Order_Id and Order_Date
from CUST_ORDER
and the second, nested cursor gets
Item_Desc from ITEM
Item_Price from INVENTORY
Order_Quantity from Order_Line
and also what I can only assume to be a calculated field which is the subtotal of each item ordered (where she got multiple items)
and another calculated field at the bottom
Order_Total
i am rather at sea on this one at the moment, would appreciate some directives :-) on how to set up the cursors...
ps - there is of course a cust_id i can access and an item_id i can access, an order_id and inventory_id...
pps - i am wondering how a cursor would deal with a calculated value - should a create a stored method so it can call it with parameters to return that paticular value?
thanks very much in advance:_)
