Object and Relational View

Explain the difference between object view and relational view.

Showing Answers 1 - 1 of 1 Answers

Diptiman

  • Dec 21st, 2015
 

A "Relational View" is the projection of the data using simple relational tables like:
CREATE OR REPLACE VIEW relational_view
(employee_name, department_name) AS
SELECT employee_name, department_name
FROM employee a, department b
WHERE a.department_id = b.department_id;
However an "Object - Relational View" is projection of data with collection of data as Object

Code
  1.  

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions