SQL2K Migration: Problem

I've got to migrate a SQL2K DB to Oracle9i.

With MS SQL I can create a default value then bind that value to a column. The idea being that if a value isn't supplied in an insert for that column then the default value will be applied.

eg
create default MAXDATE as '99991231 12:00:00'

EXEC sp_bindefault 'DBO.MAXDATE', 'XXX_UNIT.UNT_EXPIRED'

Can anybody help? Received on Sun Nov 17 2002 - 05:49:43 CST