title: how to add columns with 5000 length in oracle
body: <p>I want a table in oracle with 5 columns each of length 5000.<br>
  i am using <strong>varchar(5000)</strong> but its not allowing.    </p>
  
  <pre><code>Error starting at line 8 in command:
  ALTER TABLE WORK_STATIC_DATA_AUDIT 
  MODIFY ("NEW_VALUE" VARCHAR2(5000))
  Error report:
  SQL Error: ORA-00910: specified length too long for its datatype
  00910. 00000 -  "specified length too long for its datatype"
  *Cause:    for datatypes CHAR and RAW, the length specified was &gt; 2000;
             otherwise, the length specified was &gt; 4000.
  *Action:   use a shorter length or switch to a datatype permitting a
             longer length such as a VARCHAR2, LONG CHAR, or LONG RAW 
  </code></pre>
  
  <p>i tried <strong>CLOB</strong>, <strong>LONG</strong> but it is saying that we can have only one cloumn of CLOB or Long per table.<br>
  Please help me..</p>