title: Defining a Character Set for a column For oracle database tables
body: <p>I am running following query in SQL*Plus</p>
  
  <pre><code>CREATE TABLE  tbl_audit_trail (
    id NUMBER(11) NOT NULL,
    old_value varchar2(255) NOT NULL,
    new_value varchar2(255) NOT NULL,
    action varchar2(20) CHARACTER SET latin1 NOT NULL,
    model varchar2(255) CHARACTER SET latin1 NOT NULL,
    field varchar2(64) CHARACTER SET latin1 NOT NULL,
    stamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    user_id NUMBER(11) NOT NULL,
    model_id varchar2(65) CHARACTER SET latin1 NOT NULL,
    PRIMARY KEY (id),  
    KEY idx_action (action)
  );
  </code></pre>
  
  <p>I am getting following error: </p>
  
  <pre><code>action varchar2(20) CHARACTER SET latin1 NOT NULL,
                        *
  ERROR at line 5:
  ORA-00907: missing right parenthesis
  </code></pre>
  
  <p>Can you suggest what am I missing?</p>