oracle database procedures

[Quoted]  I need to insert this select statement into other table from writing a procedure.
[Quoted] 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/