OraFAQ Forum: SQL & PL/SQL » Generate a report using PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Generate a report using PL/SQL (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Generate a report using PL/SQL [message #225470]

Tue, 20 March 2007 00:51

dr46014
Messages: 49
Registered: February 2007

Member

Hi
I have 5 yrs of data in my table.The name of my table is transaction.I want to view this data as per the quarters of each year.Means the data will be displayed if we pass year number and quarter as parameter.Quarters are defined as Q1,Q2,Q3,Q4.
I want to view all data if the transaction data is in Q1 or Q2 ...
Means the script will ask
Year:
Quarter:

Laughing

Report message to a moderator

Re: Generate a report using PL/SQL [message #225493 is a reply to message #225470]

Tue, 20 March 2007 02:05

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select ...
where trunc(transaction_date,'Q')
      =
      trunc(to_date(:year || 
                      decode(:q,'Q1','01','Q2','04','Q3','07','Q4','10'),
                    'YYYYMM'),
            'Q')

Regards
Michel

Report message to a moderator

Previous Topic:	Insufficient privs to create sequence from procedure
Next Topic:	New Row in Table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 16:08:49 CST 2024