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 to get each name only once from an employee table?

1062

What is sql stand for?

945

What is java sql package?

1024

What kind of join is join?

903

What are functions in sql?

899

What are the sql commands?

1097

Can variables be used in sql statements?

980

What is a data definition language?

1027

What is attribute indicator in pl sql?

959

how to create a test table in your mysql server? : Sql dba

943

How to sort the rows in sql.

1008

Explain unique key in sql.

943

What is string data type in sql?

1050

What is row_number () in sql?

933

How do you go back in sql?

940