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

what is 'mysqlimport'? : Sql dba

725

What is cursor in pl sql?

766

What does the acronym acid stand for in database management?

775

What is pessimistic concurrency control? : Transact sql

831

Does asenumerable execute the query?

775

What are the properties of a transaction?

794

Can delete statement be rollbacked?

729

Do foreign keys improve performance?

748

Explain foreign key in sql?

786

How do I kill a query in postgresql?

753

What plvcmt and plvrb does in pl/sql?

1061

what is index? : Sql dba

747

How to run sql*plus commands in sql developer?

800

how to get @@error and @@rowcount at the same time? : Sql dba

739

What is mdf ldf and ndf?

744