Is there any methods by which the default values could be inserted to the column when the datatype is ROWID.
I have a query in SQL Server,
ALTER TABLE [Employees] ADD
[Empid] UNIQUEIDENTIFIER NOT NULL
CONSTRAINT [Pk] UNIQUE NONCLUSTERED ON [INDEX]
CONSTRAINT [Df] DEFAULT NEWID()
The equivalent for UNIQUEIDENTIFIER seems to be ROWID. But I was not able to give the defaullt value for the column EmpId.
Moreover, I had problems while converting the the two constraints that are defined in the same column in SQLServer. This occured becuase Oracle did not accept the CONSTRAINT keyword two times for the same column. Can we define two constraint names for the same column?