For the query try this;
Joe Celko's Sql for Smarties : Advanced Sql Programming
(The Morgan Kaufmann Series in Data Management Systems) ~
Usually ships in 24 hours
Joe Celko / Paperback / Published 1995
Our Price: $33.60 ~ You Save: $8.40 (20%)
Average Customer Review:
Read more about this title...
Joe Celko's SQL for Smarties: Advanced SQL Programming
~ Usually ships in 24 hours
Joe Celko / Paperback / Published 1999
Our Price: $35.96 ~ You Save: $8.99 (20%)
Average Customer Review:
Read more about this title...
There are a ton of interesting ideas generally using characteristic
functions
One place to get it is:
http://www.amazon.com/exec/obidos/search-handle-form/102-3948921-6839208
<http://www.amazon.com/exec/obidos/search-handle-form/102-3948921-6839208>
Russ
-----Original Message-----
From: Vijay Anand Gopalakrishnan
[mailto:[EMAIL PROTECTED]]
Sent: Monday, November 22, 1999 2:26 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: PFCSIG Hey I have a doubt in Oracle Pl/Sql
could u solve it.
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]
> [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]
