Category Archives: SQL
New page with excel reports added: Excel Reports Pls. try !!!
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
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
The Oracle ODAC (18.104.22.168.20) installation is creating an NLS_LANG entry in here: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\NLS_LANG And that has no effeckt – it should be placed in an oracle_home – like: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1\NLS_LANG The result of having the NLS_LANG in the wrong place is special … Continue reading
To complete an apps_initialize from a readonly user, the readonly user needs this grant: grant select, insert, update, delete on mo_glob_org_access_tmp to ; This has been detected on an 12.1.36 installation with a readonly solution applied.
The xls4OracleSQL 5.0is ready to be released soon and will include some new features: SmartFormat Clever formating of the SQL output. New parameter: MaxColWid enables control of how wide a column may be, before wrap is enabled. Heading width is … Continue reading
The xls4OracleSQL tool enables distribution of reports. To enable this, some new fetures has been added: Password is protected and connected to the sql. Meaning: if the sql is changed, the password is being reset, and you have to enter the password … Continue reading
The ai.sql script was suddently not working anymore… – apparently after some patching. But if you add a fnd_global.bless_next_init statement – it will. I will soon update the ai.sql in the “sql script tools“
If you think you can use any API with a procedure named ‘insert_row’ – pls. check this before you use it. The insert_row procedure is made for Orace Forms insert procedures. The insert_row is not a supported API, it will … Continue reading
select * from v$sql where module = ‘EXCEL.EXE’