Arthur-Work: 10月 2022

2022年10月28日星期五

基本款:

select replace(replace(replace(replace(?string, chr(13), ''), chr(10), ''), chr(9), ''), ' ', '') from dual

進階款:

select translate(?string, 'a ' || chr(9) || chr(10) || chr(13), 'a') from dual

2022年10月13日星期四

Q: 使用excel格式(97-2003)的BI publisher report是否筆數能超過65536筆?

A: 不行, 只能使用RTF格式, 或是把資料分割到多到工作表中. 在BI Publisher 11.1.1.9及後版本可以產生xslx檔.

Ref:

1.Can we get more than 66K records by using BI publisher reports in excel output format ?

https://community.oracle.com/mosc/discussion/4115589/can-we-get-more-than-66k-records-by-using-bi-publisher-reports-in-excel-output-format

2.Splitting the Report into Multiple Sheets (Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher)

https://docs.oracle.com/middleware/11119/bip/BIPRD/create_excel_tmpl.htm#ext_multsheets

3.BI Publisher Excel Template Layout Output is Truncating Data to 65536 Rows (Doc ID 1469264.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=533024111404255&id=1469264.1&_afrWindowMode=0&_adf.ctrl-state=orvd8jckk_4

2022年10月28日 星期五