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

List different type of expressions with the example.

931


Is there a way to automate sql execution from the command-line, batch job or shell script?

964


how to delete an existing column in a table? : Sql dba

1002


Is sql developer case sensitive?

989


Define the select into statement.

1045


How do I run a sql trace?

951


What is an exception in pl/sql?

1072


Why do you partition data?

1016


What is a pdo connection?

1022


What is cursor explain with example?

973


What is pl sql architecture?

955


What are the 3 types of behavioral triggers?

1244


What are the subsets of sql?

1119


who introduced sql?

1006


What is embedded sql what are its advantages?

1030