If any default value have been declare to that column when creating the t

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

Question Posted / meher

4 Answers
9546 Views
iFlex, I also Faced
E-Mail Answers

Answer Posted / meher

If any default value have been declare to that column when
creating the table then the defaul value will be updated.
Otherwise the column will be update by NULL.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I run a sql query?

969

What is use of package in pl sql?

952

How do sql triggers work?

989

What is database sql?

988

What are the advantages of sql?

1008

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

933

What is rank () in sql?

884

What is a sql statement?

903

What are the types of optimization?

889

Which is faster subquery or join?

1148

What is autocommit sql?

925

What is oracle and pl sql?

1081

Explain some predefined exceptions.

992

Can two tables have same primary key?

917

What are the types pl/sql code blocks?

1068