Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help!!! on SqlPlus query
I can help if you can fill in an example in the tables then what you
expect.
Mike
Hongbo Zhang wrote:
> Hi,
>
> I am new on Oracle. I have 4 following tables:
>
> HOSPITAL:
> -------------------------
> CODE_H | NAME_H |
> --------------------------
>
> MEDECIN:
> --------------------------
> CODE_M | NAME_M |
> --------------------------
>
> HOS_MED:
> ---------------------------
> CODE_H | CODE_M |
> --------------------------
>
> MED_PAT_HOS:
> -----------------------------------------------
> CODE_M | CODE_H | CODE_PATENT |
> ----------------------------------------------
>
> Would you please help me to realize this query with Oracle Sqlplus: for
> every MEDECIN,
> find the name of hospital he works and count the nomber of patients he
> treats.
>
> Thanks
>
> Hongbo
Received on Fri Apr 09 1999 - 14:00:19 CDT