How to modify the default value of a field in Oracle

How to set the default value of a field in a table in an oracle database

If the table already exists, use the following method to set the default value.

alter table table name modify field name default default value;

If the address field is set to 'Zhejiang Province' in the test table, the following statement can be used:

alter table test modify address default 'Zhejiang Province';

Oracle related introduction:

Oracle Corporation, the full name of Oracle Corporation (Oracle Software Systems Co., Ltd.), is the world's largest An enterprise software company headquartered in Redwood Beach, California, USA. Officially entered the Chinese market in 1989. In 2013, Oracle surpassed IBM and became the world's second largest software company after Microsoft.

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of How to modify the default value of a field in Oracle. For more information, please follow other related articles on the PHP Chinese website!