what commend can i use to delete all the nulls ?
i have insert a csv into a sql developer databse .
there are many nulls like this
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,716
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,717
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,718
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,719
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,720
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,721
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,722
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,723
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,724
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,725
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,726
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,727
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,728
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,729
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,730
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,731
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,732
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,733
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,734
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,735
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,736
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,737
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,738
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,739
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,740
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,741
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,742
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,743
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,744
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NULL);
--Row 111,745
INSERT INTO NAMES (YEAR, NAME, FREQUENCY, YEAR) VALUES (NULL,'',NULL,NU
what commend can i use to delete all the nulls ?
Step by step
Solved in 2 steps