Re: SQL2K migration

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 17 Nov 2002 14:08:30 +0100
Message-ID: <q35ftu0tnei5j3hrf9uke0khn3galbk53p@4ax.com>

On Sun, 17 Nov 2002 11:50:26 -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 refer to the 'CREATE TABLE' entry in the SQL reference manual in the online documentation at http://tahiti.oracle.com

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Nov 17 2002 - 07:08:30 CST