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

How do I run pl sql in sql developer?

1107

What is autocommit sql?

978

What are views in sql?

970

Mention what are different methods to trace the pl/sql code?

1194

What is sql injection owasp?

1049

Does mysql_real_escape_string prevent sql injection?

940

What is procedure explain with program?

1006

how do you login to mysql using unix shell? : Sql dba

1072

Are stored procedures faster than dynamic sql?

1023

What is sqlca in powerbuilder?

1000

Can we join 3 tables in sql?

1025

What is a pl/sql block?

1209

How is use pl and sql?

1054

What is dynamic query?

964

what are the performance and scalability characteristics of mysql? : Sql dba

994