OpenCart Templates

October, 2016

  • 19 October

    Oracle Apex: Speed up your APEX

    Sometimes i find my Apex is so slow when saving changes after development into Design page, It was from my problems, Now i find cause that it was (Off Gzip compression) into local server configuration like GlassFish Server [By Default: Off Gzip compression], To fix it please Enable Gzip compression into all network listeners, ...

August, 2016

  • 8 August

    Oracle Apex: Open multi dialog page from classic report.

    Asalamo Alikom .. I have a classic report like department list and i want to link a report column with multiple modal page and its depend on every single department. Like when i click on ‘IT’ department then open a modal page and when i click on ‘Sales’ department then ...

January, 2016

  • 24 January

    Oracle Apex API “$s()”

    The Apex JavaScript API has some very convenient functions to access the values of page items. For example, if you wante to access the contents of a text field with JavaScript, would would need to reference it something like this: [crayon-580ca4540a837922863596/] If the item you want to reference is a ...

  • 24 January

    JavaScript | Quick code

    It’s some useful of my JS snippet. To change or add holder to text input. [crayon-580ca4540affb941893411/]  

  • 23 January

    Solved | Current version of data in database has changed since user initiated update process ERROR.

    I faced this problem numerous times in APEX 4.2.6 and I finally got it to work after doing the following: Fix by .. In your query, DO NOT ALIAS any of the update-able columns by using “as” (like .. select emp_name as Name from t_emp), But remove as keyword from ...

  • 13 January

    How to cascading single/multi values into tabular form on ORACLE APEX ?

    Steps.. Create tabular form, now i want that when changed value OR selected value on cascad_id column i see cascading values into other columns. Change cascad_id type column from number column to Popup LOV (Shows return value) and insert your LOV query . Now looking for ID for cascad_id column by ...

December, 2015

  • 6 December

    Installing Java, Oracle 11g R2 Express Edition and SQL Developer on Ubuntu/Mint 64-bit

     Installing Java We start with installing Java on the machine. My personal preference is to use Oracle Java JDK. Installing this JDK could be done easily by performing the following statements. [crayon-580ca4540bf22333051953/] Notice:: You can change version from “oracle-java7-installer” to “oracle-java6-installer” or “oracle-java8-installer” .. as you want 🙂 The screen in figure ...

November, 2015

  • 6 November

    code best of #oracle_sql

    Case 1 I use COALESCE( v(‘APP_USER’),USER );  instead of NVL( V(‘APP_USER’),USER ); Cause: More performance. Case 2 I use SYS_CONTEXT(‘APEX$SESSION’, ‘app_user’) instead of V(‘APP_USER’) Cause: i can’t use v(‘APP_USER’) by default value for column but i can use SYS_CONTEXT(‘APEX$SESSION’, ‘app_user’) for default value of column    source:

  • 1 November

    Fix| Error E:Encountered a section with no Package: header, E:Problem with MergeList

    Hi, Error “E:Encountered a section with no Package: header, E:Problem with MergeList …….” Fix it by this steps ..  #linux_mint_17.2 1- Clean up.. [crayon-580ca4540d849551251569/] 2- Full update.. [crayon-580ca4540d871091900882/] Then reboot. I suspect you’ll find your errors in the GUI update tool will have gone. 🙂

September, 2015

  • 12 September

    Linux mint | How to automount drive on startup system

    To automount drive on startup system Follow this steps .. | tested on mint 17.2 Go to the Startup Applications.. Write a name for this operation such as “Mount ntfs drives”. Then in command input box, write this [crayon-580ca4540dc6e309785927/] to automount the ntfs partition. Note: You need to replace the /dev/sda2 ...