OpenCart Templates
Home / Oracle (page 2)


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-59c5281314271228451724/] If the item you want to reference is a ...

  • 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-59c52813177ff937028343/] 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:

September, 2015

  • 5 September

    How to Run GlassFish V4.1 as a Service on Linux Ubuntu/Debian

    source:   We already support running GlassFish V3 as a service on Solaris 10 and Windows platforms (see my blog).  I have been investigating how to provide support for automatically starting GlassFish V3 as a service on Linux.  Of course before I can hope to do that ...

  • 5 September

    How to use the SQL Tuning Advisor feature in Oracle SQL Developer

    First execute some codes .. [crayon-59c528131ae93916748481/] And show this toturial to help you link source:

March, 2015

  • 30 March

    Some audit codes

    Next codes help you to audit your app .. Go head… [crayon-59c528131b535597568026/]  

  • 30 March

    How to looking for item_name into all apps ?

    Sometimes you looking for item_  you forget it or not remember whats app include it.. so you use next code to find it…. [crayon-59c528131bbb2279441016/] nice day.. 🙂

  • 28 March

    How to change port listner in oracle ?

    SQLPLUS /NOLOG At the SQL Command Line prompt, enter the following command: [crayon-59c528131c237494795192/] –where password is the SYSTEM password that you set upon installation (Windows) or configuration (Linux) of Oracle Database XE. At the SQL Command Line prompt, enter the following command: [crayon-59c528131c24b337641078/] –where nnnn represents the new port number ...