- 1. Oracle ...
- (Category)
- Created on 31 October 2014
- 2. How to handle Oracle BLOB columns via Database Link ...
- (Oracle)
- Oracle Developers are often faced with the problem to handle LOB data between several oracle instances via a database link. With plain SQL it is not allowed to select, insert or update a LOB on ...
- Created on 05 October 2016
- 3. How to set manual locks to synchronize processes in Oracle ...
- (PL/SQL)
- Customers often ask, how to make sure, that a particular PL/SQL-code which runs in several sessions at the same time, process the data for the FIFO paradigm. The answer is: no problem at all. Oracle ...
- Created on 18 November 2015
- 4. 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
- 5. String Tokenizer with Oracle PL/SQL ...
- (PL/SQL)
- This article describes how to tokenize a string, just with plain "out of the box" Oracle SQL. In the IT we often encounter requirements to split a string in parts. With Oracle PL/SQL we have a quit ...
- Created on 08 December 2014
- 6. How to Java programming in Oracle Database ...
- (Java)
- This article is about how Java programs can be developed directly in the Oracle database and in particular, it shows an example how to access the file system of the operating system. Since the ...
- Created on 07 December 2014
- 7. 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
- 8. How to "Yes-No" in APEX - The Plugin
- (APEX)
- On our mobile phones we are used to have very convenient widgets to ease the handling of mobile applications. One of these widgets is a flipswitch which is perfect to show "two-state" values. For ...
- Created on 14 December 2016
- 9. 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
- 10. Downloads
- (Downloads)
- ... ill find Demo-Pages right here PL/SQL Packages PL/SQL Package for XML and JSON itstar_xml_util.zip Java Entire example for Java in the Oracle Database ...
- Created on 01 November 2014
- 11. How to create an APEX Plugin
- (APEX)
- A perfect case study for the development of APEX Plugins is the integration of Google Maps into APEX. The Plugin we will develop here should not only show a part of a map, it should also provide ...
- Created on 13 September 2014
- 12. me
- (Uncategorised)
- ... University, FH-Karlsruhe) Technologies and Skills: Oracle SQL, PL/SQL, APEX, Java, J2EE, C++, PeopleSoft Social Engangement: Keep the Environment, Refugees, Greenpeace, attac Hobby and Sports: Cycling, ...
- Created on 14 October 2012
- 13. Oracle ...
- (Tags)
- Oracle ...
- Created on 02 November 2014
- 14. How to "Yes-No" in APEX - The Plugin
- (Article tagged with: Oracle)
- On our mobile phones we are used to have very convenient widgets to ease the handling of mobile applications. One of these widgets is a flipswitch which is perfect to show "two-state" values. For ...
- Created on 14 December 2016
- 15. How to create a relation from Oracle to another physical database ...
- (Article tagged with: 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
- 16. How to create an APEX Plugin
- (Article tagged with: Oracle)
- A perfect case study for the development of APEX Plugins is the integration of Google Maps into APEX. The Plugin we will develop here should not only show a part of a map, it should also provide ...
- Created on 13 September 2014
- 17. How to handle Oracle BLOB columns via Database Link ...
- (Article tagged with: Oracle)
- Oracle Developers are often faced with the problem to handle LOB data between several oracle instances via a database link. With plain SQL it is not allowed to select, insert or update a LOB on ...
- Created on 05 October 2016
- 18. How to Java programming in Oracle Database ...
- (Article tagged with: Oracle)
- This article is about how Java programs can be developed directly in the Oracle database and in particular, it shows an example how to access the file system of the operating system. Since the ...
- Created on 07 December 2014
- 19. Oracle Goodies for XML and JSON ...
- (Article tagged with: Oracle)
- 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
- 20. String Tokenizer with Oracle PL/SQL ...
- (Article tagged with: Oracle)
- This article describes how to tokenize a string, just with plain "out of the box" Oracle SQL. In the IT we often encounter requirements to split a string in parts. With Oracle PL/SQL we have a quit ...
- Created on 08 December 2014