Home » SQL & PL/SQL » SQL & PL/SQL » Need whole ( system date )month production
icon1.gif  Need whole ( system date )month production [message #378239] Mon, 29 December 2008 07:14 Go to next message
Messages: 376
Registered: December 2008
Location: karachi
Senior Member

I Create a table Style which relate 2 column Style_no and Style_name Primary key on Style_no

And other Table is Cut

Which relate to 3 Column Cut_date,Style_id and Quantity Foreign key relate to Style_id

Now i need style_no,cut Today Quantity,and Cutting Whole month Quantity (Whole month quantity relate to System date month)

for example

if our system date is 25-DEC-08 so whole month quantity will be Month December

if our system date is 25-April-08 so whole month Quantity will be

hope you guys got my point of View

Thanks & Regards

Shahzaib Ismail
Re: Need whole ( system date )month production [message #378242 is a reply to message #378239] Mon, 29 December 2008 07:49 Go to previous messageGo to next message
Messages: 4626
Registered: February 2005
Location: East Coast USA
Senior Member
Look at TRUNC and TO_DATE.
Re: Need whole ( system date )month production [message #378284 is a reply to message #378242] Mon, 29 December 2008 15:16 Go to previous message
Kevin Meade
Messages: 2100
Registered: December 1999
Location: Connecticut USA
Senior Member
depending also on how you want your data reports you may want to look at Oracle Analytic sum. Based on the description of your need (a meager description but we work with what you give us), analytics seem appropriate.

Good luck, Kevin
Previous Topic: populate values when "not found" condition occurs
Next Topic: condition using not null
Goto Forum:

Current Time: Thu Oct 27 19:52:27 CDT 2016

Total time taken to generate the page: 0.20426 seconds