It will fill the default value through out that column by null

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

its given in pl sql block.what will hapen?

Question Posted / manoj

Answer Posted / manoj

It will fill the default value through out that column
by null

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which sorts rows in sql?

968

What is function and procedure in pl sql?

970

What is string data type in sql?

1050

When are we going to use truncate and delete?

925

Can I learn sql in a week?

1004

What is sqlca in db2?

890

What is sqlite used for?

933

Explain some predefined exceptions.

990

What are sql functions? Describe the different types of sql functions?

1057

What are pl/sql packages?

1035

What is the use of function in sql?

1028

What is the use of procedures?

924

what are date and time data types? : Sql dba

930

How show all rows in sql?

974

Can we call dml statement in function?

978