Oracle数据库中替换字段内某个值

admin

1. Select * From pdss.hospital_indication a Where a.direction_indication LIKE '%、哮喘、%' Or a.direction_indication Like '哮喘、%'  Or a.direction_indication Like '%、哮喘';
   
2. 
   
3. UPDATE pdss.hospital_indication a
   
4. SET a.direction_indication = REPLACE(a.direction_indication, '哮喘', '支气管哮喘')
   
5. WHERE a.direction_indication LIKE '%、哮喘、%' Or a.direction_indication Like '哮喘、%'  Or a.direction_indication Like '%、哮喘';

复制代码