Hi

You will have to excuse my ignorance but is this Oracle view the
equivalent to this SQL View??
Code:
Oracle

CREATE OR REPLACE VIEW e612.vw_area_child (
   area_code,
   area_name,
   row_active_ind,
   area_parent,
   area_child )
AS
select
tbl_area_master.*,
tbl_area_relation.*
from
tbl_area_master ,
tbl_area_relation
where tbl_area_relation.area_child  =  tbl_area_master.area_code(+)
Code:
SQL

CREATE VIEW [VW_AREA_CHILD]
AS SELECT [dbo].[TBL_AREA_MASTER].[AREA_CODE], [dbo].[TBL_AREA_MASTER].[AREA_NAME], [dbo].[TBL_AREA_MASTER].[ROW_ACTIVE_IND], [dbo].[TBL_AREA_RELATION].[AREA_PARENT], [dbo].[TBL_AREA_RELATION].[AREA_CHILD]
FROM [dbo].[TBL_AREA_MASTER], [dbo].[TBL_AREA_RELATION]
where dbo.tbl_area_relation.area_child  =  dbo.tbl_area_master.area_code

Thanks