title: How I can create a table having two long columns?
body: <p>I am using Oracle 10 g.</p>
  
  <p>I have a table which needs two columns of the <code>Long</code> type:</p>
  
  <pre><code>CREATE TABLE emp
   (
      id1 LONG NULL,
      id2 LONG NULL,
      //
      // Other columns.
  );
  </code></pre>
  
  <p>When I am executing this query, it is giving me this error:</p>
  
  <pre><code>Error report:
  SQL Error: ORA-01754: a table may contain only one column of type LONG
  01754. 00000 -  "a table may contain only one column of type LONG"
  *Cause:    An attempt was made to add a LONG column to a table which already
             had a LONG column. Note that even if the LONG column currently
             in the table has already been marked unused, another LONG column
             may not be added until the unused columns are dropped.
  *Action:   Remove the LONG column currently in the table by using the ALTER
             TABLE command.
  </code></pre>
  
  <p>I searched on Google, but I could not find a proper solution. Why do they not allow two columns of <code>LONG</code>?</p>
  
  <p>Is using <code>number</code> instead of a column a good idea?</p>
  
  <p>How can I achieve this?</p>