Re: SQL2K Migration: Problem

From: Frank Ashley <frank.ashley_at_ntlworld.com>
Date: Sun, 17 Nov 2002 12:22:23 -0000
Message-ID: <kKMB9.701$5R.23041@newsfep3-gui.server.ntli.net>

Sorry about that.

Frank

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:ee5ftuovvnv9gnciva9f5s7dj9u38js7fq_at_4ax.com...
> On Sun, 17 Nov 2002 11:49:43 -0000, "Frank Ashley"
> <frank.ashley_at_ntlworld.com> wrote:
>
> >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?
> >
> >
> Please do not multipost.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sun Nov 17 2002 - 06:22:23 CST