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
- 3 Answers
- 5452 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What does t sql mean?
Can we create table inside stored procedure?
Which is the correct statement about truncate and delete?
What packages(if any) has oracle provided for use by developers?
what is a composite primary key ? : Sql dba
What is sqlerrm?
How to avoid duplicate records in a query?
What is recursive stored procedure?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What does where 1 1 mean in sql?
How many types of privileges are available in sql?
What is not null in sql?
What are stored procedures used for?
What are its different types of dbms?
What is execute immediate?
