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

What is natural join in sql?

981

how to see the create table statement of an existing table? : Sql dba

1001

Is join same as left join?

1029

explain advantages of myisam over innodb? : Sql dba

1060

How do I find duplicates in a single column in sql?

1013

how can we repair a mysql table? : Sql dba

970

What does the sign mean in sql?

983

What is sql and db2?

993

How many types of cursors supported in pl/sql?

1178

What does over partition by mean in sql?

970

What is autocommit sql?

979

what are the nonstandard string types? : Sql dba

1134

How do I order columns in sql?

993

How to run sql statements through the web interface?

1034

What is trigger and stored procedure in sql?

1027