It shouldn't occured any error. It'll update but value is empty(

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

its given in pl sql block.what will hapen?

Question Posted / selvan

Answer Posted / selvan

It shouldn't occured any error.
It'll update but value is empty(i.e columns having empty
values)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

If a cursor is open, how can we find in a pl/sql block?

1252

Can delete statement be rollbacked?

1065

what is dbms? : Sql dba

1070

Does group by remove duplicates?

1120

Is inner join faster than left join?

1287

what are aggregate and scalar functions? : Sql dba

1142

define sql insert statement ? : Sql dba

1110

Is primary key always clustered index?

1101

Do we need to rebuild index after truncate?

1154

What is the current version of sql?

1106

how to start mysql server? : Sql dba

1279

What is the current version of postgresql?

1188

what is collation? : Sql dba

1242

What is your daily office routine?

2353

what are the advantages of sql ? : Sql dba

1154