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"
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][i]Originally posted by marist89 [/i]
[B]You can't use ORDER BY in a view. [/B][/QUOTE]
You can as of Oracle 8.1
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width