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

What is pivot in sql?

915

Name the different types of indexes in sql and define them.

1151

What type of database is cloud sql?

1101

Can we insert in view in sql?

1059

what is the difference between a having clause and a where clause? : Sql dba

1087

What is the syntax and use of the coalesce function?

1173

What is clustered index sql?

984

What is sql architecture?

1048

Enlist the data types that can be used in pl/sql?

1073

Does truncate require commit?

974

What is primary and foreign key?

1064

How can we make an if statement within a select statement?

1013

Which function is used to return remainder in a division operator in sql?

1140

How to raise user-defined exception with custom sqlerrm ?

1129

What is pragma in pl sql?

1110