How is the default used in Oracle?

In Oracle database, the DEFAULT keyword is used to specify a column’s default value. If a value for that column is not specified when inserting data, the database will automatically use the default value. For example, the DEFAULT keyword can be used when creating a table to specify a default value for a column.

CREATE TABLE employees (
    id INT,
    name VARCHAR(50),
    department VARCHAR(50) DEFAULT 'IT'
);

In the example above, if a value is not specified for the department column when inserting data, the database will automatically set it as “IT”. The DEFAULT keyword can be used for most data types in creating tables, modifying table structure, and inserting data.