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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / pgnath

Answers were Sorted based on User's Feedback



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

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

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

Answer / akki julak

if you gave a default value for that column

then it takes that default value

otherwise it takes NULL

Is This Answer Correct ?    7 Yes 2 No

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

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

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

Answer / kolla radha sri seshu

In SQL you will get the message 'X' rows updated
In PL / SQL you will get the message pl / sql procedure
sucessfully completed

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

What programs use sql?

0 Answers  

can i call procedure in package

3 Answers   TCS,

is mysql query is case sensitive? : Sql dba

0 Answers  

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

What is a cursor for loop ?

4 Answers  

How collections are improve the performance?

1 Answers   Polaris,

Which certification is best for sql?

0 Answers  

What is a stored procedure ?

9 Answers  

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

What does truncate mean in sql?

0 Answers  

What are commit, rollback, and savepoint?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories