Post reply

Conversion

  • November 13, 2003 at 12:28 pm

    #160183

    I'm attempting to convert this SQL CREATE TABLE script into an Oracle DDL. But I'm not sure how the 'ntext' & TEXTIMAGE_ON attributes translate to Oracle. Can someone assist?

    if exists (select * from dbo.sysobjects where id = object_id(N'[standards].[CSG Special Request Reasons]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

    drop table [standards].[CSG Special Request Reasons]

    GO

    CREATE TABLE [standards].[CSG Special Request Reasons] (

    [Code] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [Short Description] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [Definition] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [Stop Date] [smalldatetime] NULL

    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    GO

  • November 13, 2003 at 1:20 pm

    #481951

    They have CBLOB datatype which can hold 4GB of data

  • November 13, 2003 at 1:49 pm

    #481963

    CBLOB is the oracle datatype that can be used for both ntext and TEXTIMAGE_ON datatypes?

  • November 13, 2003 at 1:54 pm

    #481965

    Basically when an ntext datatype is used you have textimage_on on that table. Its not a datatype.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply