top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Can null keys be entered in cluster index, normal index in Oracle?

0 votes
123 views
Can null keys be entered in cluster index, normal index in Oracle?
posted Dec 18, 2014 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

Yes, it can be.

answer Dec 19, 2014 by Arun Gowda
Similar Questions
+1 vote

I am using below statement but i got error.
ALTER TABLE XXXtable
ADD xxx_name varchar2(50) not null;

error message:
ORA-01758: table must be empty to add mandatory (NOT NULL) column

...