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

its given in pl sql block.what will hapen?

Answer Posted / manoj

It will fill the default value through out that column
by null

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can ddl statements be used in pl/sql?

594


Can we commit in trigger?

545


What is the difference between subquery and correlated query?

528


What is the difference between an inner and outer join?

537


what is a control file ? : Sql dba

575






What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

535


What is a ddl command?

532


Define commit, rollback and savepoint?

573


What is nvarchar in sql?

520


what is a field in a database ? : Sql dba

541


Are subqueries better than joins?

528


What is a memo field?

525


What is basic structure of pl sql?

498


How many developers work on postgresql?

559


What is normalization sql?

511