Re: ID/Counter datatype.

Guang Yang (sunlight_at_iastate.edu) wrote:
: Does anyone happen to know whether Oracle provides the similar datatype
: as identifier/counter in SQL-server/Access, which could be incremented
: by system automatically without using SQL to fill in that field. If that
: datatype is not available in Oracle, is there a way to create another
: approach to inplement similiar type, such as a view?

I think what you are looking for is called a SEQUENCE in Oracle-ese. :-) Read up on SEQUENCEs in the documentation. It's not a datatype or column property in Oracle. SEQUENCEs are another database object that are used to generate sequential numbers.

				Good luck,
				Teresa Larson

     _________________________________________________________________
    /  Teresa A. Larson                 http://www2.ari.net/jmasino/ /
   /  Bell Atlantic                          Voice: (301) 282-0224  /
  /  13100 Columbia Pike, A-3-3              Fax:   (301) 282-9416 /
 /  Silver Spring, MD  20904         Teresa.A.Larson_at_bell-atl.com /
/________________________________________________________________/
                      #include <std_disclaimer>