we have oracle db. we have a table that has 3 columns, one of the column is type number. we want to have a sequence (nextVal) that will simple generate a new number for this number column each time a row gets inserted. how can we have such a nextval on this number type column set ? can anyone share the actual sample insert sql that can do this ? we do not want to use Trigger.
thx