x15270772831的博客

–创建序列create sequence test_seq start with 1 increment by 1;–根据序列自增插入数据到test表中insert into test(pk_value) select test_sep.nextval from dual . . . ....

单表操作select mac(a),b,max(time) from test desc group by b;多表关联group by 取每组最新一条select max(a.b_id),max(a.title), max(t.name), max(t.price) from a inner join (select * from b order by id, price...

Oracle时间戳（毫秒）转为DateSELECT TO_CHAR(1112070645000 / (1000 * 60 * 60 * 24) + TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD HH:MI:SS') AS CDATE FROM PDA_ORDER t以1970年时间作...