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 meaning of <> in sql?

1067

What is error ora-12154: tns:could not resolve the connect identifier specified?

1077

What is offset in sql query?

1111

What are the two virtual tables available at the time of database trigger execution?

1222

What is spool?

1050

What is normalisation in sql?

1053

What is difference between db2 and sql?

997

How to look at the current sql*plus system settings?

1149

What is implicit cursor in pl sql?

1090

What is a call statement? Explain with an example.

1006

How to execute a stored procedure?

1089

what are the types of subquery? : Sql dba

1103

What are the parameter modes supported by pl/sql?

1106

Why is nosql good?

1023

how can we destroy the cookie? : Sql dba

1011