Is this Oracle View the same as this SQL View?
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