Create force view

Can somebody tell me what's the main difference between create view and create force view
and does the foloowing command works :

CREATE FORCE VIEW last_first_vu
AS SELECT name ll', 'll job "Employee & Position", department_id "Department"
FROM employee
ORDER BY name
GROUP BY department_id;



Thanks a bunch

Using the FORCE keyword will create the view wether the objects exist or not.

You can't use ORDER BY in a view.

Also, FORCE will ensure that the view is created regardless on user's priviliges for the table on which the view is based..

Quote:

---

Originally posted by marist89
You can't use ORDER BY in a view.

---

You can as of Oracle 8.1

HTH,