EBS Cloning 更改颜色Java 色彩设计

set lines 200 pages 50000
col profile_option_value for a30
select o.profile_option_name,
       v.profile_option_id,
       v.level_id,
       v.level_value,
       v.profile_option_value
  from fnd_profile_options o, fnd_profile_option_values v
 where o.profile_option_id = v.profile_option_id
   and o.profile_option_name='FND_COLOR_SCHEME' and level_id=10001;

update fnd_profile_option_values v
   set v.profile_option_value = 'RED'
 where v.level_id = 10001
 and v.profile_option_id =
       (select profile_option_id
          from fnd_profile_options o
         where o.profile_option_name = 'FND_COLOR_SCHEME');
commit;