if you set default value then it will update column with null 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 / ehtesham malik

Answer Posted / ehtesham malik

if you set default value then it will update column with
null value.

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are analytical functions in sql?

968

Explain what is dbms?

985

How to look at the current sql*plus system settings?

1079

what is text? : Sql dba

1007

Which one is better subquery or joins?

1008

What is data abstraction in sql?

965

What is a system versioned table?

928

What is the purpose of the sql select top clause?

1019

What is database sql?

982

What do you understand by exception handling in pl/sql?

961

What is string join?

932

what is a trigger in mysql? : Sql dba

1068

Why do we use sqlite?

915

What is not equal in sql?

1006

What is delimiter in pl sql?

987