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

What is the current version of sql?

1106

Can delete statement be rollbacked?

1065

what are all the common sql function? : Sql dba

1141

how to use regular expression in pattern match conditions? : Sql dba

1125

what is sql server agent? : Sql dba

1189

Is primary key clustered index?

1028

what are aggregate and scalar functions? : Sql dba

1142

how to start mysql server? : Sql dba

1279

What is your daily office routine?

2353

What is the best sql course?

1064

how many tables will create when we create table, what are they? : Sql dba

1156

Is primary key always clustered index?

1101

Can we use distinct and group by together?

1147

How do I remove duplicates in two columns?

1202

Do we need to rebuild index after truncate?

1154