select 'update sys_cube_columns set title='''
||comments||''' where schema_name=''ys'' -----ys是模式名
and table_name=''vw_'||table_name
||''' and field='''||column_name||''' and (title is null or title='''' or length(title)=0);'
sql from all_col_comments where comments is not null limit 100000;