if we give update table_name set column_name= default.
what will happen?
Answer Posted / meher
If any default value have been declare to that column when
creating the table then the defaul value will be updated.
Otherwise the column will be update by NULL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the two types of cursors in pl sql?
is it possible to pass an object or table to a procedure as an argument?
What is partition in sql query?
How many types of functions are there in sql?
What are tables and fields in the database?
What does closing a cursor do?
What are some emotional triggers?
What is sql data?
What do you know by pl/sql cursors?
What is update query?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is the trigger in sql?
How to get help at the sql prompt?
How do I create an index in word?
What is the difference between local and global temporary table?