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

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

its given in pl sql block.what will hapen?

Question Posted / pgnath

Answers were Sorted based on User's Feedback

if we give update table_name set column_name= default. what will happen? its given in pl sql blo..

Answer / manoj

It will fill the default value through out that column
by null

Is This Answer Correct ?

7 Yes

0 No

if we give update table_name set column_name= default. what will happen? its given in pl sql blo..

Answer / gopal

If default is speceified for the table then it will update
with default value. Else it will update null values

Is This Answer Correct ?

6 Yes

1 No

if we give update table_name set column_name= default. what will happen? its given in pl sql blo..

Answer / guest

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

Is This Answer Correct ?

3 Yes

0 No

if we give update table_name set column_name= default. what will happen? its given in pl sql blo..

Answer / ehtesham malik

if you set default value then it will update column with
null value.

Is This Answer Correct ?

1 Yes

1 No

if we give update table_name set column_name= default. what will happen? its given in pl sql blo..

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