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 recursive stored procedure?

1101

What is interval partition?

1060

Why is normalization important?

1032

Can you have more than one key in a database?

937

What is clustered index in sql?

1054

What is the difference between having and a where in sql?

1110

What is dynamic sql in pl sql?

1037

what are the differences between char and varchar? : Sql dba

1076

How many types of primary keys are there?

1040

What are the different parts of a package?

1115

Is sql database free?

983

How do I pipe the output of one isql to another?

1007

What is difference sql and mysql?

992

What is data profiling in sql?

1084

Define implicit and explicit cursors.

1150