Re: oracle database procedures

Hi, Kushan

insert into ...
select
  WORK_ORDER_NO
 ,PROPERTY_UNIT
 ,G3E_USERNAME_GROUP_TYPE
FROM (
   select

      GIS_JOB_ID WORK_ORDER_NO


     ,'785' PROPERTY_UNIT


     ,MIN(

          G3E_USERNAME || ' ' || GROUP_TYPE ||' '
         ) G3E_USERNAME_GROUP_TYPE


     ,STATE

     ,GROUP_TYPE

     ,G3E_USERNAME

     ,INSTALL_TYPE


     ,VOLTAGE_RATING


    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

In article <954rp5$lod$1_at_nnrp1.deja.com>,   kushan <vikasmamta_at_my-deja.com> wrote: > 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/
>

--
Stax



Sent via Deja.com
http://www.deja.com/