inserting default value along with other columns

inserting default value along with other columns

References

Reference NO 1

http://stackoverflow.com/questions/15201714/inserting-default-value-along-with-other-columns

Reference NO 2

http://stackoverflow.com/questions/230662/insert-default-value-when-parameter-is-null

Reference NO 3

http://blog.sqlauthority.com/2011/04/09/sql-server-add-new-column-with-default-value/

Reference NO 4

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2575782100346318728

Reference NO 5

http://www.postgresql.org/docs/9.1/static/sql-insert.html

Reference NO 6

http://en.wikipedia.org/wiki/Insert_(SQL)

Reference NO 7

http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/admin/r0000970.htm

Reference NO 8

http://db.apache.org/derby/docs/10.7/ref/rrefsqlj81859.html