摘要:
查询主键是哪几列select table_name,column_name from user_cons_columns a,( select constraint_name from user_constraints where table_name='TR_COUNTRY_BASE_M' and 阅读全文
摘要:
2019.7.17 15:44 add --字符内容含A或Cselect * from ( select 1 id, 'ABC' s1 from dual union all select 2 id,'AC' s1 from dual union all select 3 id,'BC' s1 fr 阅读全文
摘要:
先替换非数字的为空,再截取 with tmp_a as ( select '2018-10-15 12:30:59' update_time from dual union all --结果是 20181015 select '2017/10/16 12:30:59' update_time fro 阅读全文