It shouldn't occured any error. It'll update but value is empty(

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

its given in pl sql block.what will hapen?

Question Posted / selvan

Answer Posted / selvan

It shouldn't occured any error.
It'll update but value is empty(i.e columns having empty
values)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

explain the difference between delete , truncate and drop commands? : Sql dba

1140

Why is sql better than hql?

1060

What is on delete restrict?

1066

How can you fetch first 5 characters of the string?

1059

Explain 3 basic parts of a trigger.

1371

What is crud stand for?

1046

Is sql harder than python?

1152

What is linq to sql?

1175

How do I view output in sql developer?

1117

What are the types of sql commands?

1151

what is sp_pkeys? : Transact sql

1199

what is an extent ? : Sql dba

1155

What is the default isolation level in sql server? : Transact sql

1079

Can 2 queries be executed simultaneously in a distributed database system?

1187

Can we use commit inside a trigger?

1140