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.


CREATE TABLE Login ( ID int NOT NULL, USERNAME varchar(255) DEFAULT 'GUEST', PASSWORD varchar(255), LAST_LOGIN_ON date DEFAULT sysdate );

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

Solution Worked 0 UpvotesUpvote

        

Solution Didn't Worked 0 DownvotesDownvote



Comments



Search