ORA-00907: missing right parenthesis in sql

Question

   SQL> create table customer(  
    2  CUST long varchar(5));  

Getting a error :- ORA-00907: missing right parenthesis

I want to 5 CHARACTER LONG of CUST

Answer 1

In SQL Server (and other databases) you can have composite primary key (e.g. more than one column can be a primary key). You would use CONSTRAINT keyword, e.g. for example:

    CREATE TABLE [dbo].[Depositor]
                (
                    cust_no int NOT NULL,
account_no int NOT NULL,

                          CONSTRAINT [PK_Depositor]
                          PRIMARY KEY CLUSTERED ([cust_no], [account_no])
                          WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON
                                , ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80
                               ) ON [PRIMARY]
                ) ON [PRIMARY];

Foreign key constraints are normally created using the following syntax:

ALTER TABLE [dbo].[Depositor] WITH CHECK
        ADD
            CONSTRAINT [FK_Depositor_Cust_No]
            FOREIGN KEY ([cust_no])
            REFERENCES [dbo].[Customer] ([cust_no]);

Answer 2

Good day,

As much as I know "LONG VARCHAR" is DB2 or SQL/DS Datatype !

It is NOT oracle datatype which uses LONG (can store variable-length character data containing up to two gigabytes of information.) and NOT SQL Server data type which uses VARCHAR(MAX)

https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT1830

More information of equivalent data types between oracle and DB2 or SQL/DS you can find in this link:

https://docs.oracle.com/cd/A58617_01/server.804/a58241/ch5.htm

In short, you cannot execute queries in a language which the server not support! If you want to use SQL Server then you should use TSQL :-)