title: Oracle 11g R2 Express, Auto Increment in lowercase
body: <p>I have problem on auto increment in lowercase. Based on this <a href="https://stackoverflow.com/questions/9733085/auto-increment-for-oracle">Auto Increment for Oracle</a> question, I'm able to create auto increment but the table still in uppercase character. </p>
  
  <p>How can I actually do it in lower case. </p>
  
  <p>Here is my list of SQL:</p>
  
  <pre><code>CREATE TABLE  "myTable" 
     (    "tableID" NUMBER(*,0) primary key, 
          "tableColumn" VARCHAR2(30) 
     ) ;
  
  CREATE SEQUENCE "tableID_SEQUENCE"
  START WITH 1
  INCREMENT BY 1;
  
  CREATE OR REPLACE TRIGGER "tableID_TRIGGER"
  BEFORE INSERT ON "myTable"
  FOR EACH ROW
  BEGIN
  SELECT tableID_SEQUENCE.nextval INTO NEW.tableID FROM dual; //at this line, what changes needed to?
  END;
  
  INSERT INTO "myTable" ("tableColumn") VALUES ('ABC');
  </code></pre>
  
  <p>So currently I'm stuck at trigger query : </p>
  
  <pre><code>SELECT tableID_SEQUENCE.nextval INTO NEW.tableID FROM dual; 
  </code></pre>