.....В простом представлении разрешены все однострочные операции, однако 
запрещены конструкции order by, ссылки на несколько таблиц в табличном 
соединении, группирование операций set, конструкции group by.......

If a view is defined by a query that contains SET or DISTINCT operators, a
GROUP BY clause, or a group function, then rows cannot be inserted into,
updated in, or deleted from the base tables using the view.

Feature            Simple Views Complex Views
Number of tables  One             One or more

A view which is being outer-joined is currently
merged only if it is  "simple."  For example:
SELECT Col1, Col2, ... FROM T;

You can define views with any query that references tables, snapshots, or other
views; however, the query that defines a view cannot contain the ORDER BY or FOR
UPDATE clauses

SQLWKS> create or replace view tb_test_v as
      2 > select
      3 > owner, table_name
      4 > from
      5 > tb_test
      6 > order by  1 
      7 > 
Предложение обработано.

SQLWKS> create or replace view tb_test_v as
      2 > select
      3 > owner, table_name
      4 > from
      5 > user_tables
      6 > order by  1 
      7 > 
order by  1 
*
ORA- 00933 : неверное завершение SQL-предложения