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

its given in pl sql block.what will hapen?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

663


How do I run a program in pl sql?

499


Is sql low level language?

574


define data blocks ? : Sql dba

544


Are left and right joins the same?

529






How to change sql*plus system settings?

541


How do I turn a list into a table?

504


What are predefined functions in sql?

531


Explain what is sql*plus?

670


what are the advantages and disadvantages of cascading style sheets? : Sql dba

547


What is server name sql?

590


Why use truncate instead of delete?

546


Which sql statement is used to return only different values?

501


Is it possible for a table to have more than one foreign key?

582


Is ms sql traffic encrypted?

503