if we give update table_name set column_name= default.
what will happen?

Answer Posted / mano chinna

It Will update NULL to the column. In SQL, while
inserting and updating if you are assigning a column value
as DEFAULT keyword without single or doubled quote it will
take NULL automatically.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between a web-garden and a web-farm? : Sql dba

754


Does sql between include endpoints?

748


What is the difference between union and union all command?

741


Why do we use %rowtype & %type in plsql?

786


Can we use two order by clause in query?

738






What is sqlite format?

816


What is a sql statement?

692


Where do we use pl sql?

724


What is the use of sqldataadapter?

704


What is record in pl sql?

773


What is constant in pl sql?

708


What is cartesian join in sql?

744


what is 'trigger' in sql? : Sql dba

726


What is sql used for?

856


Explain autonomous transaction.

843