if we give update table_name set column_name= default.
what will happen?
Answers were Sorted based on User's Feedback
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 |
Answer / akki julak
if you gave a default value for that column
then it takes that default value
otherwise it takes NULL
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / 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 |
Answer / kolla radha sri seshu
In SQL you will get the message 'X' rows updated
In PL / SQL you will get the message pl / sql procedure
sucessfully completed
Is This Answer Correct ? | 0 Yes | 3 No |
which will fire first ? Trigger or Constraint
24 Answers i2, IBM,
How to use transactions efficiently : transact sql
What is cold data?
what is bcp? When does it used? : Sql dba
Can we enter data in a table in design view?
How are sql commands classified?
How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?
Why is %isopen always false for an implicit cursor?
how to get a list of columns in an existing table? : Sql dba
Explain polymorphism in pl/sql.
table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.
Can we rollback after truncate?