Nov 13, 2018
ALTER TABLE MODIFY column helps to change column datatype to another datatype, set default values, add NULL checks, change scale or size etc
OracleTutorial.Net brings you a cool easy to understand Oracle tutorial posts. Here is a post on how to modify the following things of an existing column of any existing table in Oracle database.
Datatype
Scale or Size
Visibility
Set default value
Add NULL or NOT NULL check
How cool is that? Support this oracle tutorial by hash by giving a thumbs up. Love you all. <3
Thanks
Hash
Website: oracle tutorial