Re: Problem with the data type

Either a suitable numeric datatype (NUMBER(10) etc) accompanied by a row-level trigger, or else RAW(16) and a default value of SYS_GUID() <http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions168.htm>.

-----Original message-----
From: Shwe Yee Than
Date: 19/11/07 07:32
> Hi,
>
> I'm using oracle 10g in Linux OS. What data type can I use if I want
> the table to automatically increase the id (the primary key) of the
> table when I insert the values into the table?
> For example, we use "serial" data type in postgres database system.
>
> Can anyone help me? Thanks in advance.
>
> Regards,
> Shwe <http://us.rd.yahoo.com/evt=51732/*http://overview.mail.yahoo.com/>

--
http://www.freelists.org/webpage/oracle-l