Home » SQL & PL/SQL » SQL & PL/SQL » Fifo , Lifo and Average Method Inventory (window Xp Developer 6i 10g database)
Fifo , Lifo and Average Method Inventory [message #404376] Thu, 21 May 2009 10:22 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Dear all member

i have three tables

Opening
Purchase
Sale

Opening table contain
Item_no,
Item_name,
Op_qty,
Op_rate

Purchase Table contain
Item_no,
Item_name,
Purchase_qty,
Purchase_rate

And Sale Table Contain
Item_no,
Item_name,
Sale_qty,


what will be the sql/ plsql querry for Fifo , Lifo and Average method Stock

Please give me any idea


Regards


Shahzaib ismail
Re: Fifo , Lifo and Average Method Inventory [message #404378 is a reply to message #404376] Thu, 21 May 2009 10:28 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Messages: 209

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: Fifo , Lifo and Average Method Inventory [message #404381 is a reply to message #404376] Thu, 21 May 2009 10:38 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
More than 200 posts and you don't knwo how to post.

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Post a working Test case: create table and insert statements along with the result you want with these data.

Quote:
what will be the sql/ plsql querry for Fifo , Lifo and Average method Stock

This is meaningless in RDBMS. RDBMS works on sets, sets have no first or last element.

Regards
Michel
Previous Topic: Clob, PLSQL table type, Collections
Next Topic: Should I use global temporary table?
Goto Forum:
  


Current Time: Thu Dec 08 12:33:14 CST 2016

Total time taken to generate the page: 0.10240 seconds