Noor wrote:
> How could we write a query for a view to create from two tables as per
> details below?
>
> Table One Stock
> comprising of columns A/C no, date processed and received stock.
>
> And other table ISSUE
>
> Comprising of columns A/C, date processed, issued stock
>
> now how to create a view Stock balance from the above tables to gave us
> detailed balance record?
>
> View Comprising of columns A/C, date processed, Received Stock, Issued
> Stock and Balance
> Group by A/C arrange by processed date.
>
> Is the creation of above is possible is yes what is that query.
>
> If not possible then what other solution could be gave me details
> answer
>
> My emails address is
> tarakai348_at_yahoo.com
>
> Thanks in advance for help
This is, I presume, classroom work based on an Oracle example of
pipelined table functions. If your go to tahiti.oracle.com, or look in
Morgan's Library, and do your homework you will find the demo.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jan 25 2007 - 11:41:27 CST
