How To Create View

 

CREATE or REPLACE VIEW NG_CLUSTER_UNIT_V AS

  SELECT HOU.ORGANIZATION_ID, HOU.NAME, DECODE(HOU.ORGANIZATION_ID, 101, 'Talha Group', 100, 'Zaber Group', '99', 'Zaber Group', '') AS GROUP_NAME

  FROM HR_OPERATING_UNITS HOU

  

  

SELECT * from NG_CLUSTER_UNIT_V