UPDATE table_name
SET VARIATION = ‘Apple’
WHERE VARIATION like ‘Course aseem%’
Those with a SqlServer background will be familiar with the UPDATE .. FROM syntax.
For example (totally made up)
1: update employee_bonus
2: set bonus = 0
3: from employee_bonus b
4: inner join employees e on b.employee_id = e.employee_id
5: where e.bonus_eligible = 'N'
Those who transitioned from SqlServer to Oracle might find the absence of the UPDATE FROM a significant loss. The best Oracle alternative that I know of is as follows.
1: update (select bonus
2: from employee_bonus b
3: inner join employees e on b.employee_id = e.employee_id
4: where e.bonus_eligible = 'N') t
5: set t.bonus = 0
Advertisements
