Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

if we give update table_name set column_name= default.
what will happen?

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


Please Help Members By Posting Answers For Below Questions

What are the two types of cursors in pl sql?

1124


is it possible to pass an object or table to a procedure as an argument?

1178


What is partition in sql query?

1045


How many types of functions are there in sql?

1007


What are tables and fields in the database?

1189


What does closing a cursor do?

1373


What are some emotional triggers?

1035


What is sql data?

1034


What do you know by pl/sql cursors?

1170


What is update query?

1033


Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1057


What is the trigger in sql?

1004


How to get help at the sql prompt?

1164


How do I create an index in word?

1074


What is the difference between local and global temporary table?

1088