var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Updating partial column value
I have a table named 'country' with a varchar2 type column name 'country_status'.
This column has value like below :
‘This is a developed country’
‘This is not a developed country’
I would like to update the part of the column value ‘developed’ as ‘developing’ as below:
‘This is a developing country’
‘This is not a developing country’
My query : Is there any way to achievethis using a single query without using the pl/sql block?
Thanks with Regards,
More details in the manual: http://docs.oracle.com/cd/E11882_01/...153.htm#i78608
set country_status = replace(country_status, 'developed', 'developing')
You should have stored the description of the status in a separate table together with a code and then reference that code from the country table.
What happens if you need to translate that description sometime?
Thanks Shammat for the solution and valuable suggestion.