if we give update table_name set column_name= default.
what will happen?
- 4 Answers
- 8716 Views
- iFlex, I also Faced
- E-Mail Answers
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
Can a procedure in a package be overloaded?
What are inner outer left and right joins in sql?
What is primary key and foreign key with example?
What is procedure in pl sql?
what is a view? : Sql dba
what is table? : Sql dba
What are primary key and foreign key and how they work?
Can you load data into multiple tables at once? : aql loader
How do you remove duplicate records from a table?
What is a native sql query?
What is a sql instance vs database?
what is sp_pkeys? : Transact sql
What are sql*plus environment variables?
What is structural independence and why is it important?
Is it possible to create startup or shutdown trigger for on-schema?
