if we give update table_name set column_name= default.
what will happen?
Answer Posted / mano chinna
It Will update NULL to the column. In SQL, while
inserting and updating if you are assigning a column value
as DEFAULT keyword without single or doubled quote it will
take NULL automatically.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Can you selectively load only those records that you need? : aql loader
Does user triggers have entry for trigger with compilation errors?
Explian rowid, rownum?
Does truncate need commit?
What is sql used for?
How many types of relationship are there?
What is a table in a database?
how can we know the number of days between two given dates using mysql? : Sql dba
What is memory optimized?
what are the properties and different types of sub-queries? : Sql dba
Could you please provide oca (oracle 10g) dumps for my certification ?
What is sql keyword?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Is merge a dml statement?
What is optimistic concurrency control? : Transact sql