Re: Problem with the data type

  • From: William Robertson <william@xxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 19 Nov 2007 07:45:55 +0000

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/>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2007