- 1. How to create a relation from Oracle to another physical database ...
- (Oracle)
- ... exactly this was the question of a customer, because he wants to join tables between two Oracle databases. Well, the idea for this solution is based upon the fact, that we can have a foreign key constraint ...
- Created on 26 July 2015
- 2. How to set manual locks to synchronize processes in Oracle
- (PL/SQL)
- ... the session has already set the same lock return true if (po_lock_result in (0, 4)) then return(true); else -- otherwise return false return(false); end if; end; [...] ...
- Created on 18 November 2015
- 3. How to copy data with "Long Raw" columns
- (PL/SQL)
- From time to time I will be faced the problem to move data from one table to another. Under normal circumstances this is not a big deal, but if the source table contains a long-/raw column this is impossible ...
- Created on 27 September 2015
- 4. How to Java programming in Oracle Database
- (Java)
- ... , because of the complexity of the parameter. Second, we need another PL/SQL function, which handles the parameter passing from Java to PL/SQL. This is the function we provide as an external interface, ...
- Created on 07 December 2014
- 5. Oracle Goodies for XML and JSON
- (PL/SQL)
- XML and JSON are perfect to manage and transfer structured data on the internet. But in a relational database like oracle the data is stored in tables who can be linked via joins. This article ...
- Created on 27 September 2014
- 6. How to create an APEX Plugin
- (APEX)
- ... the ability to place multiple markers on the map. The positions of the markers will be passed as a string which contains a JSON object. All the other information will come from settings of the Plugin itself. ...
- Created on 13 September 2014