title: How to set all column from null to not null in table in oracle
body: <p>I have 1 table having <strong>40</strong> columns. Out of <strong>40</strong> columns only <strong>5</strong> columns are <strong>NOT NULL</strong> and rest of the columns are set as <strong>NULL</strong>. How can i set all <strong>NULL</strong> column to <strong>NOT NULL</strong> in one time or in TOAD. Is there any possibility to do this except manually set as NOT NULL.</p>