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

cleaned up a bit:

Code:

---

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

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.

Quote:

---

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?

Code:

---

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

---

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

Thanks for your help!