Home » Server Options » Text & interMedia » table with sequnce
table with sequnce [message #76162] Wed, 15 December 2004 07:55 Go to next message
Gowtham
Messages: 3
Registered: February 2004
Junior Member
hi folks      !

i want to design a table with one of field with sequence as one of the field (which is basically number data type) .
Re: table with sequnce [message #76165 is a reply to message #76162] Thu, 16 December 2004 06:30 Go to previous message
Just John
Messages: 69
Registered: November 2004
Member
I am not sure if Oracle supply this as part of standard Table creation (column definition).

But in the old days (will still work) you had to create a database ON_INSERT/ON_UPDATE trigger, or set the default value for the column.

I would investigate new table creation scripts (post 9i) I am pritty sure they were not abailiable in 8.

Enjoy.
Previous Topic: Accessing Database of Oracle using thin driver of JDBC
Next Topic: Are the following characters supported in oracle 8i
Goto Forum:
  


Current Time: Thu Mar 28 18:23:47 CDT 2024