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

What is scalar function in sql?

1038


How can we solve sql error: ora-00904: invalid identifier?

1246


Explain select statements in sql?

1056


What is the process of debugging?

1070


Explain what is dbms?

1062


What is bulk collect in pl sql?

1088


How to order siblings in oracle hierarchy queries?

1047


What does an inner join do?

1180


Where not exists in sql?

979


what is 'trigger' in sql? : Sql dba

1086


Is it important to partition hard disk?

1024


What are packages in pl sql and also explain its advantages?

1040


How do you add a column to a table?

1055


How much does sql cost?

1001


How long it takes to learn pl sql?

1010