title: Add a column SQL query in Oracle database
body: <p>I am using Oracle Database (version is 9i) and I want to add a column to a current table in oracle database.</p>
  
  <p>I want to add an integer column to keep track of invalid tries per user, so default value should be 5.</p>
  
  <p>When I try to execute this query in Sql*Plus it gives an error table or view doesn't exist ( I have double checked table name is correct.</p>
  
  <pre><code>ALTER TABLE CustApps_user ADD VALID_TRIES INT DEFAULT 5 NOT NULL;
  </code></pre>