Add a column with a default value to a table in Oracle SQL

In some situation, you need to add some Default value to a Column in a Table in SQL. For example, In "Login" table, if there is a "username" column which is used to store the username, but if the username is not yet saved then "username" should have by default value "GUEST". So, Let's see how to do it in Oracle SQL.

In the above query, two columns "username" and "LAST_LOGIN_ON" have been given default values "GUEST" and sysdate respectively.

Giving is the Master Key to Success, in all applications of human life.