Oracle - Sequence dependent on another column?
<p>How do I create a sequence that is dependent on another column?</p>

<p>For example:
I have a table <code>CAR</code></p>

<pre><code>MAKE  | CAR_NO | COLOR | MODEL
_____________________________
Honda   1        S      Civic
Honda   2        B      Civic
Honda   3        W      Civic
Toyota  1        S      Camry
Toyota  2        B      Camry
Mazda   1        W      3
</code></pre>

<p>So <code>CAR_NO</code> is the sequence and it is dependent on the column <code>MAKE</code>. </p>

<p>How can this be done?</p>