IT WILL UPDATE NULL IN THE COLUMN IF YOU NOT PROVIDE ANY VALUE.

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

its given in pl sql block.what will hapen?

Question Posted / guest

Answer Posted / guest

IT WILL UPDATE NULL IN THE COLUMN IF YOU NOT PROVIDE ANY
VALUE.

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is your daily office routine?

2353

how to escape special characters in sql statements? : Sql dba

1124

Can we use distinct and group by together?

1147

what is collation? : Sql dba

1242

how to start mysql server? : Sql dba

1279

Do we need to rebuild index after truncate?

1154

Is inner join faster than left join?

1287

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

1156

what is bcp? When does it used? : Sql dba

1065

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

1252

what is schema? : Sql dba

1163

How do I remove duplicates in two columns?

1202

what are aggregate and scalar functions? : Sql dba

1142

Can we rollback truncate?

1083

Can delete statement be rollbacked?

1065