Author Archive

sql-aggregate functions

December 21, 2014 admin SQL, 0

Using Rollup, Cube, Grouping and Grouping Sets. Rollup – operation: It is a sub-class of group by-clause, aggregating the select statement’s output. For our test, the promotions – table in sh schema is used, SELECT P.PROMO_CATEGORY, P.PROMO_END_DATE, P.PROMO_COST FROM PROMOTIONS P ORDER BY P.PROMO_CATEGORY; PROMO_CATEGORY […]

Oracle forms11g batch – conversion

October 15, 2013 admin Forms11G, 23

Convert Oracle Forms modules to Oracle Forms Script in batch-mode Let’s convert our forms modules contained in ModuleSource directory. Just create a simple dos-script: @Echo OFF cls Echo converting Forms Modules from fmb format to to fmt format…. for %%f IN (*.fmb) do frmcmp userid=summit/summit@xe module=%%f batch=YES script=YES module_type=FORM compile_all=yes window_state=minimize Echo FINISHED CONVERTING FORMS […]

Oracle forms11g batch-compile

October 14, 2013 admin Forms11G, 3

Compile forms modules in batch-mode We can run the Migration Assistant in batch mode on Windows and UNIX computers. We will do the test on WindowsXp system If we have an application with many forms modules, let’s say for example, more than 60 forms modules and we have made a change in one or more […]

Configure WebUtil in Forms11gR2

May 25, 2013 admin Webutil & icons in Forms11gR2, 92

How to configure WebUtil in Forms11gRelease2 Download jacob-1.14.3 from here Copy Jacob.jar to <Oracle_Home>forms\java Copy jacob-1.14.3-x64.dll to <Oracle_Home>formswebutil\win64 Copy jacob-1.14.3-x86.dll to <Oracle_Home>formswebutil\win32 Modify the archive-tag archive in formsweb.cfg by adding jacob.jar # Forms applet

Deploy icons in Forms11gR2

May 23, 2013 admin Webutil & icons in Forms11gR2, 5

Deploying icons in forms11g To deploy Forms applications on the web that contain icons in buttons and in tree control items, you’ll first need to convert the icon files into GIF or JPG format Create a folder that contains your gif-files Example: (F:iconsapp) Create a jar-file that contains the gif-files in a dos-command […]