Category Archives: xls4OracleSQL

Added new page with Excel Reports

New page with excel reports added: Excel Reports Pls. try !!!

Posted in Applications development, Excel Reports, Excel tools, SQL, xls4OracleSQL | Comments Off on Added new page with Excel Reports

xls4OracleSQL is in use as Excel Reporting tool in a validated environment

The xls4Oracle is now in use as a reporting tool. New features in xls4OracleSQL, is enabling the build of Excel Reports, using xls4OracleSQL. The Excel files is store in a SharePoint folder, with restricted access. The ProtectData parameter enables protection of both sql … Continue reading

Posted in Excel Reports, Excel tools, SQL, xls4OracleSQL | Comments Off on xls4OracleSQL is in use as Excel Reporting tool in a validated environment

Duplicates in a Query

Here is a way to find out why you have two rows in a select, when you only expect one. In good database design you expect that a unique ID is giving you only one record. But many tables Oracle … Continue reading

Posted in Applications development, SQL, xls4OracleSQL | Comments Off on Duplicates in a Query