# Oracle auto\_increment ? & Rails

**URL:** <https://www.ruby-forum.com/t/oracle-auto-increment-rails/75352>\
**Category:** Rails\
**Created:** [March 1, 2006, 7:34pm UTC](https://www.ruby-forum.com/t/oracle-auto-increment-rails/75352 "2006-03-01T19:34:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![axle988](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e47774/32.png) [@axle988](https://www.ruby-forum.com/u/axle988)\
**Post date:** [March 1, 2006, 7:34pm UTC](https://www.ruby-forum.com/t/oracle-auto-increment-rails/75352/1 "2006-03-01T19:34:06Z")

</div>

To make a new istance of an Oracle table with Rails, i need that this  
table had a column named ‘id’. This ‘id’ must be Primary Key &  
auto\_increment;.  
How Can I modify the ‘id’ properties to do it Auto\_increment in Oracle?

---

<div class="post-metadata">

**Author:** ![axle988](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e47774/32.png) [@axle988](https://www.ruby-forum.com/u/axle988)\
**Post date:** [March 1, 2006, 11:15pm UTC](https://www.ruby-forum.com/t/oracle-auto-increment-rails/75352/2 "2006-03-01T23:15:59Z")

</div>

Hi Ivan,

In Oracle you need to tie a trigger to a sequence, which in turn is  
tied to an id field in a table… I use 8i, there may be a better way  
in later versions.

I hope this helps (a little)

Mark

On 01/03/06, Ivan M. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

–  
Mark P.

[www.markpanay.com](http://www.markpanay.com)  
Jargon Free Web D.

---

<div class="post-metadata">

**Author:** ![axle988](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e47774/32.png) [@axle988](https://www.ruby-forum.com/u/axle988)\
**Post date:** [March 2, 2006, 12:25am UTC](https://www.ruby-forum.com/t/oracle-auto-increment-rails/75352/3 "2006-03-02T00:25:51Z")

</div>

Ivan M. wrote:

> To make a new istance of an Oracle table with Rails, i need that this  
> table had a column named ‘id’. This ‘id’ must be Primary Key &  
> auto\_increment;.  
> How Can I modify the ‘id’ properties to do it Auto\_increment in Oracle?

You could try:

create table foo (id integer not null, acolumn varchar(10));  
create sequence foo\_seq;

Rails will automatically use foo\_seq.nextval as the id when inserting  
new rows into the foo table.

-mark