Re: View and Select

"Nikki" <netranger28_at_hotmail.com> wrote in message news:<08k%9.539210$F2h1.20898_at_news01.bloor.is.net.cable.rogers.com>...
> Hi ,
>
> Can someone help me with this Select statement and creating a VIEW. TIA!!!
>
>
> 1)display all entries in the stock table where the stock name starts with a
> C
>
> 2)create a view called manager_cash that contains the manager number and the
> total cash in portfolios managed by the manager.
>
> MANAGER
> Manager Manager
> Number Name Salary
>
> M1 Smith 45000.00
> M2 Brown 62500.00
> M3 Jones 43900.00
>
>
> STOCK
> Stock Stock Current
> Symbol Name Price
>
> JFM Jetform 21.75
> JDS JDS Fitel 20.55
> NTL NorTel 54.10
> COS Corel 3.16
> MLT Mitel Corp. 14.30
> CSN Cognos 27.50
> RIM Research In Motion 90.95
>
>
> PORTFOLIO
> Portfolio Manager
> Number Number Cash
>
> P001 M2 25000
> P004 M3 10000
> P005 M2 50000
> P008 M3 37500
> P011 M3 8000
>
>
> HOLDING
> Portfolio Stock Purchase Number Purchase
> Number Symbol Date Shares Price
>
> P001 JFM 10-1-1998 300 19.55
> P004 NTL 10-2-1998 200 52.90
> P001 CSN 10-5-1998 150 29.90
> P005 MLT 10-6-1998 500 12.00
> P001 JFM 9-30-1998 300 19.30
> P008 COS 9-29-1998 800 4.50
> P008 CSN 9-29-1998 500 25.00
> P001 NTL 9-30-1998 250 56.40
> P005 COS 9-30-1998 1200 3.60
> P001 CSN 10-6-1998 250 29.75
> P001 COS 10-7-1998 200 3.50
> P001 JFM 10-2-1998 300 19.55
> P004 MLT 10-13-1998 200 12.20
> P005 MLT 10-13-1998 600 12.25
> P008 JDS 10-28-1998 610 21.50
> P008 JFM 10-14-1998 500 20.50
Please provide the e-mail address of your instructor, so we can e-mail him your homework directly

Regards

Sybrand Bakker
Senior Oracle DBA Received on Mon Feb 03 2003 - 09:33:17 CET