title: Default Values For Columns Oracle 9i
body: <p>Hi I am running following query in sql plus</p>
  
  <pre><code>CREATE TABLE yii_profiles (
    user_id NUMBER(11) NOT NULL,
    lastname varchar(50)  NOT NULL DEFAULT '',
    firstname varchar(50) NOT NULL DEFAULT '',
    birthday date NOT NULL DEFAULT '0000-00-00',
    PRIMARY KEY (user_id)
  );
  </code></pre>
  
  <p>I am getting following error. Can you tell where am I going wrong. I tried various ways but no success.</p>
  
  <p>ERROR at line 3:
  ORA-00907: missing right parenthesis</p>