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




Reply With Quote