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
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Hellow
Experts


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
April


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
joy_division
Messages: 4963
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: 2103
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: Tue Feb 11 13:41:47 CST 2025