1、使用concat连接字符
CONCAT(CONCAT(b.CREATEDATE,' '), b.CREATETIME) CREATEDATE
注:oracle中使用concat,concat只能连接两个字符,而“||”可以连接多个字符。因此,用concat连接多个字符时,需要嵌套。
参考:
https://blog.csdn.net/qq_41536539/article/details/91978135
https://blog.csdn.net/u014158708/article/details/48180541?utm_source=blogxgwz2
2、日期合并
select * from (select a.id,a.docsubject bt,a.doccreatedate||' '||a.doccreatetime rq from docdetail a where a.seccategory = 150 order by doccreatedate desc , doccreatetime desc )a where rownum <=10