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 sequence in sql?
explain the difference between delete , truncate and drop commands? : Sql dba
Are dml statements autocommit?
Can we use two order by clause in query?
Can sql developer connect to db2?
How to run sql statements with oracle sql developer?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Why do we use procedures?
What is clause?
How to display Row Number with Records in Oracle SQL Plus?
Why plvtab is considered as the easiest way to access the pl/sql table?
what are the properties and different types of sub-queries? : Sql dba
What pl/sql package consists of?
explain the delete statements in sql
Can we perform dml in function?