title: oracle: why cant i insert into view
body: <p>I created a simple view with columns from a single table. When i try to insert values into the table, i get the ORA_01732 error that dml is not legal on this view. I DO have an order by clause in the view definition which I've gathered is not allowed for it to be inherently updatable and I'm seeing that I probably have to use an INSTEAD OF type clause in the view definition. Can someone show me how I would build the view to be updatable this way?</p>
  
  <p>here is the create view statement:</p>
  
  <pre><code>create view CUST_VIEW
  as select customer#,firstname,lastname,state
  from book_customer
  order by state, lastname;
  </code></pre>