How much "NULL" values you can define for the "NULL" Data Type Column in SQL ?

In SQL, the NULL data type represents the absence of a value. When defining a column as NULL, it means that the column can contain NULL values. The number of NULL values that can be specified for a NULL data type column is unlimited. This means that you can have any number of NULL values in a column defined as NULL.

In your example, the “shape” column in the “fruit_details_tbl” table is defined as NULL. This means that you can have any number of NULL values in the “shape” column. Other columns like “name”, “color”, and “taste” are defined as NOT NULL, which means they cannot contain NULL values.

To insert NULL values into the “shape” column, you can use the INSERT statement and specify NULL as the value for the “shape” column:

INSERT INTO fruit_details_tbl (name, shape, color, taste)
VALUES ('Apple', NULL, 'Red', 'Sweet');

You can insert multiple rows with NULL values in the “shape” column if needed.