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
How many indexes can be created on a table in sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is difference between procedure and trigger?
What are tables and fields?
how to run 'mysql' commands from a batch file? : Sql dba
How do I run a program in pl sql?
Why cross join is used?
What is a subquery in sql?
What is structural independence and why is it important?
What is a unique constraint?
What are the different dml commands in sql?
How do I run a sql script?
What is dml and ddl?
what are wild cards used in database for pattern matching ? : Sql dba
Does sql*plus also have a pl/sql engine?