If default is speceified for the table then it will update with default v

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

its given in pl sql block.what will hapen?

Question Posted / gopal

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Does a join table need a primary key?

908

What does truncate mean in sql?

969

Why is theta join required?

1091

What are the different types of dbms?

965

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2117

Should I use mbr or gpt?

961

How can you know that statistics should be updated?

1033

What is the execution plan in sql?

979

Does mysql_real_escape_string prevent sql injection?

912

What is sql and also describe types of sql statements?

1007

What is a stored procedure in sql with example?

1064

Why do we use procedures in pl sql?

971

What is an ndf file?

935

What is difference between hql and sql?

1002

What are the types of keys?

942