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
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?
How do I run a program in pl sql?
Is sql low level language?
define data blocks ? : Sql dba
Are left and right joins the same?
How to change sql*plus system settings?
How do I turn a list into a table?
What are predefined functions in sql?
Explain what is sql*plus?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is server name sql?
Why use truncate instead of delete?
Which sql statement is used to return only different values?
Is it possible for a table to have more than one foreign key?
Is ms sql traffic encrypted?