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
What is scalar function in sql?
How can we solve sql error: ora-00904: invalid identifier?
Explain select statements in sql?
What is the process of debugging?
Explain what is dbms?
What is bulk collect in pl sql?
How to order siblings in oracle hierarchy queries?
What does an inner join do?
Where not exists in sql?
what is 'trigger' in sql? : Sql dba
Is it important to partition hard disk?
What are packages in pl sql and also explain its advantages?
How do you add a column to a table?
How much does sql cost?
How long it takes to learn pl sql?