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

(133 Views)

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.