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?

its given in pl sql block.what will hapen?

Answer Posted / gopal

If default is speceified for the table then it will update
with default value. Else it will update null values

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql exception?

974


Why having clause is used in sql?

978


How exception is different from error?

1017


What is cursor in pl sql with examples?

1033


Can two tables have same primary key?

976


What are the different parts of a package?

1115


How to select all records from the table?

1136


Are subqueries better than joins?

976


What is primary key and foreign key?

960


Can we call stored procedure in function?

958


What are some emotional triggers?

985


How do I access sql anywhere database?

969


What do you understand by pl/sql packages?

1058


what is the difference between group by and order by in sql? : Sql dba

1128


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1829