Results 1 to 3 of 3

Thread: RowID ...

  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Unanswered: RowID ...

    Dear Team,

    If a column is defined as ROWID datatype, will Oracle insert default values into the column without the values being inserted into the columns.

    Thanks
    Sridhar

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    no

  3. #3
    Join Date
    Feb 2004
    Posts
    9
    Hi,

    Thanks for your reply.

    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?

    Thanks for your time.

    Regards
    Sridhar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •