随笔分类 - Oracle
摘要：原SQL语句select t.mail_no,wm_concat(t.notice_no) as notice_no_all from ardba.arbino t group by t.mail_no错误信息解决SQLselect a.mail_no,wm_concat(a.notice_no) || max(a.str) as notice_no_all from (select k.mail_no,k.notice_no, case when k.all_sum > 4000 then '...' else null end as str from(select t
阅读全文
摘要：SQL中的单记录函数1.ASCII返回与指定的字符对应的十进制数;SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual; A A ZERO SPACE--------- --------- --------- --------- 65 97 48 322.CHR给出整数,返回对应的字符;SQL> select chr(54740) zhao,chr(65) chr65 from dual;ZH C-- -赵 A3
阅读全文
