Suppose we have defined a unique on a column of a table? So at max how many null values can one insert for the same column.
Also using Single query how to display numbers from 1 to 100
Printable View
Suppose we have defined a unique on a column of a table? So at max how many null values can one insert for the same column.
Also using Single query how to display numbers from 1 to 100
select rownum from sys.all_tables where rownum <=100 ;
You can insert any number of null values as NULL is not a value .
and NULL <> NULL.