error in datatype when running sql aganist oracle

Hi

this sql gives error message says invalid datatype when running aganist oracle it works well on sql server
how to make it work well with oracle?

Code Snippet

CREATE TABLE mokh_tb_fellows(
id [int] IDENTITY(1,1) NOT NULL,
ccode [int] NULL,
fellowname [nvarchar](50) NULL,
marital [nvarchar](50) NULL,
nationality [nvarchar](50) NULL,
id_type [nvarchar](50) NULL,
id_num [nvarchar](50) NULL,
gender [nvarchar](50) NULL,
mobile [nvarchar](50) NULL,
address [nvarchar](50) NULL,
typeofrelation] [nvarchar](50) NULL,
CONSTRAINT [mokh_tb_fellows_pk] PRIMARY KEY
(
[id] ASC
)
)


thanks in advance.

[849 byte] By [seco] at [2008-1-7]
# 1

Hi, seco,

The data types in SQL server and Oracle do not match exactly,

so please change the data type to the ones which could be supported in Oracle according to the following table.

Oracle data type SQL Server data type Alternatives

BFILE

VARBINARY(MAX)

Yes

BLOB

VARBINARY(MAX)

Yes

CHAR([1-2000])

CHAR([1-2000])

Yes

CLOB

VARCHAR(MAX)

Yes

DATE

DATETIME

Yes

FLOAT

FLOAT

No

FLOAT([1-53])

FLOAT([1-53])

No

FLOAT([54-126])

FLOAT

No

INT

NUMERIC(38)

Yes

INTERVAL

DATETIME

Yes

LONG

VARCHAR(MAX)

Yes

LONG RAW

IMAGE

Yes

NCHAR([1-1000])

NCHAR([1-1000])

No

NCLOB

NVARCHAR(MAX)

Yes

NUMBER

FLOAT

Yes

NUMBER([1-38])

NUMERIC([1-38])

No

NUMBER([0-38],[1-38])

NUMERIC([0-38],[1-38])

Yes

NVARCHAR2([1-2000])

NVARCHAR([1-2000])

No

RAW([1-2000])

VARBINARY([1-2000])

No

REAL

FLOAT

No

ROWID

CHAR(18)

No

TIMESTAMP

DATETIME

Yes

UROWID

CHAR(18)

No

VARCHAR2([1-4000])

VARCHAR([1-4000])

Yes

More information, please visit

http://technet.microsoft.com/en-us/library/ms151817.aspx

Hope this helps,

Regards

YuGuo–MSFT at 2007-10-2 > top of Msdn Tech,Windows Forms,Windows Forms Data Controls and Databinding...