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 primary and foreign key?

1062

What are the sql aggregate functions?

1128

What is %type in sql?

965

What are the syntax and use of the coalesce function?

1202

What are analytical functions in sql?

1028

Is t sql a programming language?

1064

what is denormalization. : Sql dba

1109

How do I tune a sql query?

974

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

1070

What are pl/sql cursor exceptions?

1101

what are the 'mysql' command line options? : Sql dba

1072

Can we use pl sql in sql server?

1081

What is denormalization in a database?

1053

Explain exception handling in pl/sql?

1033

What does inner join mean?

1165