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 / 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


Please Help Members By Posting Answers For Below Questions

Can you selectively load only those records that you need? : aql loader

1046


Does user triggers have entry for trigger with compilation errors?

1034


Explian rowid, rownum?

1010


Does truncate need commit?

942


What is sql used for?

1124


How many types of relationship are there?

1027


What is a table in a database?

1043


how can we know the number of days between two given dates using mysql? : Sql dba

1046


What is memory optimized?

1082


what are the properties and different types of sub-queries? : Sql dba

1032


Could you please provide oca (oracle 10g) dumps for my certification ?

5156


What is sql keyword?

998


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2569


Is merge a dml statement?

977


What is optimistic concurrency control? : Transact sql

981