title: create a view with hard coded values without writing insert
body: <p>Hi i'm creating a view in the following way</p>
  
  <pre><code>CREATE OR REPLACE FORCE VIEW tableA (field1, field2)
  AS
    SELECT 
      CAST("state" AS        CHAR(2)),
      CAST("LOCALITY_NAME" AS   CHAR(31)),
    FROM tableB;
  </code></pre>
  
  <p>I need to add one more column called 'id' and populate it with hard coded value 'abc' for all the rows. Is it possible to do that while creating the view? I have seen <a href="http://www.sql-server-performance.com/forum/threads/view-with-hard-coded-values.14433/" rel="nofollow">this thread</a> , but i was not able to understand how it fits in my case.</p>