title: Oracle Apex SQL Create View
body: <p>How to stop a multi-table view from updating an underlying table?</p>
  
  <p>to be specific here is the question:</p>
  
  <p>Create a VIEW to list holiday IDs, holiday description and countries. The view should also include a column that lists USA as “America”, India as “Asia”, China as “Asia”, and Spain as “Europe”; <strong>but your solution must not update or add to data in the tables</strong>. Make sure you supply the full SQL statement showing the view creation. Write a SELECT statement to test the view.</p>
  
  <pre><code>Create or replace view v_holiday as
  select "DETAILS_OF_HOLIDAY"."HOLIDAYCODE" as "HOLIDAYCODE",
         "DETAILS_OF_HOLIDAY"."COUNTRYVISITED" as "COUNTRYVISITED",
         "DETAILS_OF_HOLIDAY"."HOLIDAYDESCRIPTION" as "HOLIDAYDESCRIPTION" 
  from "DETAILS_OF_HOLIDAY" "DETAILS_OF_HOLIDAY"
  </code></pre>