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

how can we replace the particular column value of a resulted
set of executed query? I mean write down a sql query to
chane the particular column's value of a resulted set of
executed query

Question Posted / aplus

Answers were Sorted based on User's Feedback



how can we replace the particular column value of a resulted set of executed query? I mean write do..

Answer / m.raghu

by using sub query answer is

update table1 set col1=(select col2 from table2 where
<cond>)

Is This Answer Correct ?    2 Yes 1 No

how can we replace the particular column value of a resulted set of executed query? I mean write do..

Answer / mglbayar

UPDATE (SELECT t1.col1 c1, t2.col1 c2
FROM table1 t1, table2 t2
WHERE t1.pk = t2.fk AND more_condition)
SET c1 = c2;

Is This Answer Correct ?    2 Yes 1 No

how can we replace the particular column value of a resulted set of executed query? I mean write do..

Answer / suma

select decode(salary,2500,1000,3000,2500, 3000) from
employees;
This query will replace the salary column value from
employees.
If the salary is 2500 then 1000 is displayed in the
resultset, else if 3000 then 2500 will be displayed esle
2000 is displayed.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the use of nvl function?

0 Answers  

in a package one procedure is wrong package shows valid or not

4 Answers  

What is rownum in sql?

0 Answers  

what are different types of collation sensitivity? : Sql dba

0 Answers  

What is attribute indicator in pl sql?

0 Answers  

What is a sql statement?

0 Answers  

what happens if you no create privilege in a database? : Sql dba

0 Answers  

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

What is benefit of creating memory optimized table?

0 Answers  

Does sql require a server?

0 Answers  

Is stored procedure faster than query?

0 Answers  

Explain isolation levels. : Transact sql

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories