1.以日期字段为条件查询信息SQL语句
select * from table where to_char(flt_date,‘yyyy-mm-dd’)=‘2019-10-23’;
2.类型为CLOB的字段查找
select * from table where dbms_lob.instr(name_content,‘xiaoerlang’,1,1)>0
order by insert_time desc;
Oracle语句
最新推荐文章于 2024-07-19 12:06:45 发布