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

How many sectors are in a partition?

1031

What is trigger with example?

1012

What is the difference between nvl function, ifnull function, and isnull function?

1050

what are all the common sql function? : Sql dba

1010

Is hadoop a nosql?

948

What is the command used to fetch the first 5 characters of a string?

1150

What is form and report?

925

What are different joins used in sql?

1007

Is left join same as inner join?

1021

Write a query to find the names of users that begin with "um" in sql?

924

how do you know if your mysql server is alive? : Sql dba

1024

what is meant by nl2br()? : Sql dba

973

What are the types of records?

951

Is sql a programming?

933

What is using in sql?

1016