if you set default value then it will update column with null value.

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

its given in pl sql block.what will hapen?

Question Posted / ehtesham malik

Answer Posted / ehtesham malik

if you set default value then it will update column with
null value.

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we join 3 tables in sql?

1100

Could you please provide oca (oracle 10g) dumps for my certification ?

5237

Explain the difference in execution of triggers and stored procedures?

1059

What is information schema in sql?

1112

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

1092

how to select unique records from a table? : Sql dba

1170

How can triggers be used for the table auditing?

1117

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1006

Explain cursor types?

1078

What happens when a trigger is associated to a view?

966

What is database sql?

1092

what are aggregate and scalar functions? : Sql dba

1104

what is the use of friend function? : Sql dba

1056

how to analyze tables with 'mysqlcheck'? : Sql dba

1049

Does pl sql work in mysql?

1032