Dear friends,
My questions are
1) how Pragma is used in Pl/sql or stored procedures ?
2) Given these tables, write a query to print out sales by month (across the
page), by customer.
TABLEA
CUST NAME SIGNED CONTRACT
1450 Mercy Clinic 01-JAN-99 SPEC0001
3230 Childrens Hosp 03-JAN-99 PLET0008
5420 General Hosp 20-FEB-99 HVCB0002
TABLEB
CUST INVDATE QTY PRICE CONTRACT
1450 12-DEC-98 1 10000 SPEC0001
1450 19-DEC-98 2 20000
1450 05-JAN-99 1 9000 SPEC0001
1450 04-FEB-99 1 10000
3230 01-JAN-99 1 10500 PLET0008
3230 15-JAN-99 1 10000 PLET0008
3230 1-FEB-99 1 10000 PLET0008
3230 15-FEB-99 1 10500
5420 1-FEB-99 1 5000 HVCB0002
5420 8-FEB-99 1 5000 HVCB0002
5420 15-FEB-99 1 5000
5420 22-FEB-99 1 5000
5420 29-FEB-99 1 5000 HVCB0002
5420 3-MAR-99 1 5000 HVCB0002
5420 10-MAR-99 1 5000 HVCB0002
5420 17-MAR-99 1 5000
5420 24-MAR-99 1 5000 HVCB0002
5420 2-APR-99 1 5000 HVCB0002
The output should look like this:
Jan Feb Mar
Customer Name Revenue Revenue Revenue
1450: Mercy Clinic $9,000 $10,000 $0
3230: Childrens Hosp $20,500 $20,500 $0
5420: General Hosp $0 $20,000 $20,000
Please solve the above problems......
Please help me in this........
Urs
VJ
>From: "Daniel Coppersmith" <[EMAIL PROTECTED]>
>Reply-To: "Daniel Coppersmith" <[EMAIL PROTECTED]>
>To: "Rendra Yap" <[EMAIL PROTECTED]>
>CC: "PFCSIG" <[EMAIL PROTECTED]>
>Subject: Re: PFCSIG Using single menu at several windows
>Date: Mon, 22 Nov 1999 07:51:40 -0500
>
>Each window will have it's own instance of the menu. How are you obtaining
>a reference to the window? Be sure you are getting the window's reference
>as such:
>
>m_master lm_menu
>
> lm_menu = this.menuId // Assuming that this script is at the
>window level
> lm_menu.m_file.m_save.enabled = False
>
>D
>
>----- Original Message -----
>From: Rendra Yap <[EMAIL PROTECTED]>
>To: PBPFC Mailing List (E-mail) <[EMAIL PROTECTED]>; PFC mailing list
>(E-mail) <[EMAIL PROTECTED]>
>Sent: Monday, November 22, 1999 1:40 AM
>Subject: PFCSIG Using single menu at several windows
>
>
> >
> > I have single menu (called m_master inherit from m_frame) and I want to
> > attach all window master with m_master.
> > At the m_master, I disable one item called m_save.
> > And in every window master has a datawindow, at editchanged event I
>enabled
> > that m_save.
> > And then I open several window master, after that I see at the toolbar
>(from
> > that menu) from each window, and the disabled menu is correct. If I
>edited
> > the datawindow, the m_save was enabled, but when I changed to other
>window
> > master, the m_save enabled too.
> > Is that a PFC bug or not ?
> >
> > How to manage that enabled menu for many windows ?
> > Do you think that I must create a menu for each window ?
> >
> > Regards,
> > Rendra Yap
> > Bussiness Development System
> > PT. Surabaya Agung Industri Pulp & Kertas
> > E-mail : [EMAIL PROTECTED]
> > ICQ # 37557798
> >
> >
> >
> > > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE
>COMMANDS,
>ADDRESS
> > > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
>pfcsig
> > > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> >
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
>ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
>pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
