Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6429 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 is difference between pls_integer and integer?
Why do we use triggers?
What is the sql query to display the current date?
Which one is faster ienumerable or iqueryable?
what is auto increment? : Sql dba
Are stored procedures faster than queries?
What is the meaning of disabling a trigger?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How can you view the errors encountered in a trigger?
What does partition by mean in sql?
What is a sql statement?
What is the maximum number of columns in sql table?
What is the difference between count 1 and count (*) in a sql query?
What are different types of triggers?
What is the largest value that can be stored in a byte data field?
