if you gave a default value for that column then it takes that default v

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

Question Posted / akki julak

Answer Posted / akki julak

if you gave a default value for that column

then it takes that default value

otherwise it takes NULL

Is This Answer Correct ?

7 Yes

2 No

Please Help Members By Posting Answers For Below Questions

When is the update_statistics command used?

1115

What is difference between sql and mysql?

1129

What is normalization in a database?

1152

What is sql keyword?

998

What are user defined functions?

1012

What is restrict in sql?

1109

How do you update a table in sql?

984

What is the least restrictive isolation level? : Transact sql

1063

What are the uses of sysdate and user keywords?

1101

What is pl sql package?

1031

Can you inner join the same table?

988

Explain mutating table error.

1200

How many types of literals are available in pl sql?

1115

What is a field in a database?

1063

What is gpt format?

936