Category Archives: oracle applications

sql4oracle.zip updated

New files: x4o_objects – script to create the xls4oracle objects view. Joins lots of informations: SQL> desc x4o_objects  Name                                    ————————————-  OWNER                                   OBJECT_NAME                             OBJECT_DESCRIPTION                      LAST_UPDATE_DATE                        OBJECT_TYPE                             SOURCE                                  DOWNLOAD                                UPLOAD                                 load.sql – script to generate upload and download script. locks.sql – change … Continue reading

Posted in oracle applications, scripts for sqlplus, Using sqlplus | Leave a comment

sql4oracle.zip updated with new and updated files

The following scripts has been added – and lots of updates: header – show $header from database source objects ccid – show segment values for a ccid ubj – @obj on user objects cnt – count number rows in multiple … Continue reading

Posted in oracle applications, scripts for sqlplus | Leave a comment

The par.sql script updated

The par.sql script updated to use v$parameter2. This will show paramteres like control_files and utl_file_dir like this:  control_files              /u000/app/oradata/XXXX/cntrl01.dbf control_files              /u000/app/oradata/XXXX/cntrl02.dbf control_files              /u000/app/oradata/XXXX/cntrl03.dbf

Posted in oracle applications, scripts for sqlplus | Leave a comment

Concurrent Request – prevent printing empty reports

Here is a solution to prevent printing of “empty reports”. This solution will update the copies to zero on the concurrent request – and prevent any print of empty (or nearly empty) pages. The trick is to add a counter of … Continue reading

Posted in oracle applications | Leave a comment

Select from language views (VL views) finds nothing…

Often when just installed a new tool, you will find that proven sql’s is not working. Reson for this can be your registry nls_lang is defaulted to the windows language. Solution: open regedit find all occurences of “NLS_LAN” update to … Continue reading

Posted in oracle applications | Leave a comment

Oracle canonical formats for flexfields

Flexfields are varchar2 datatype, but will handle number and dates. So to store a char value – no action is required – but for dates and numbers, you must use the canonical functions: To store a number into a flexfield … Continue reading

Posted in flexfields, oracle applications | Leave a comment