不记得什么时候写的记录

1、Oracle全文搜索

select * from all_objects where object_name='XXXX';

2、Oracle生成UUID函数

select sys_guid() from dual;

3、针对UNION结果进行排序

select 
    a_a a,a_b b
from 
    a
union 
select 
    b_a a,b_b b
from b
order by a;

4、排序指定null位置

select * from xx order by column_a nulls first;
select * from xx order by column_a nulls last;

5、CASE

select
case when mb.video_name is not null then 'video'
     when mb.audio_name is not null then 'audio'
     when mb.original_flag = 'N' then 'forward'
else
　　'miblog'
end as dynamicType 
from miblog_blog