Re: oracle database procedures

You can only group selected columns.

Günther

kushan schrieb:

> I need to insert this select statement into other table from writing a
> procedure.
> select GIS_JOB_ID WORK_ORDER_NO ,'785' PROPERTY_UNIT, G3E_USERNAME
> || ' ' || GROUP_TYPE ||' '
> from COMMON_N, SWGEAR_N, G3E_FEATURE
> WHERE G3E_FEATURE.G3E_FNO = 320 AND COMMON_N.G3E_FNO =
> G3E_FEATURE.G3E_FNO AND COMMON_N.G3E_FID
> AND (STATE = 'ABN' OR STATE = 'REM' OR STATE = 'INS' OR STATE
> = 'PPA')
> GROUP BY GIS_JOB_ID, STATE, GROUP_TYPE, G3E_USERNAME,
> INSTALL_TYPE, VOLTAGE_RATING
>
> Can I use this group by clause.
> Would it be grouped in the same manner as in the statement in other
> table. If not tell me the way to do this.
>
> Please help me out.
>
> Thanks
> --
> kushan
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Jan 30 2001 - 20:35:54 CET