Is this Oracle View the same as this SQL View?

[holly]

Hi

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

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(+)

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

[techgnome]

cleaned up a bit:

CREATE VIEW VW_AREA_CHILD
AS SELECT AREA_CODE, AREA_NAME, ROW_ACTIVE_IND, AREA_PARENT, AREA_CHILD
FROM TBL_AREA_MASTER
INNER JOIN TBL_AREA_RELATION
ON tbl_area_relation.area_child  =  tbl_area_master.area_code

And besides the fact that the all caps on the tables & field names drive me nuts....
That should jsut about do it.


TG

[brucevde]

They are not the same. The Oracle view uses a Left Join, which is indicated by the (+) after tbl_area_master.area_code. The SQL view has an Inner Join.

[techgnome]

Originally posted by brucevde
They are not the same. The Oracle view uses a Left Join, which is indicated by the (+) after tbl_area_master.area_code. The SQL view has an Inner Join.

I wondered about that (never worked w/ Oracle)....
This then would be the equivelent, no?

CREATE VIEW VW_AREA_CHILD
AS SELECT AREA_CODE, AREA_NAME, ROW_ACTIVE_IND, AREA_PARENT, AREA_CHILD
FROM TBL_AREA_MASTER
LEFT JOIN TBL_AREA_RELATION
ON tbl_area_relation.area_child  =  tbl_area_master.area_code

[holly]

Thanks alot techgnome........ and thanks brucevde for spotting the obvious...I too wondered what the + was for???

Thanks for your help!