- 1. How to create a relation from Oracle to another physical database ...
- (Oracle)
- ... on a view. So let's go ahead: 1. We create a view which points to a table/view on the foreign database, using a database link: create view test_view_dblink as select * from some_table@external_oracle_database; 2 ...
- Created on 26 July 2015
- 2. How to handle Oracle BLOB columns via Database Link
- (Oracle)
- ... the remote system. This ends up with a error like this: "ORA-22992 cannot use lob locators selected from remote tables". There are three solutions for this Solution 1: SQL Subquery Thank ...
- Created on 05 October 2016
- 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. String Tokenizer with Oracle PL/SQL
- (PL/SQL)
- ... the most important crew members of the USS Enterprise: SELECT regexp_substr(str, '[^,]+', 1, LEVEL) AS splitted_element, LEVEL AS element_no FROM (SELECT rownum AS id, 'Kirk,Spock,Scotty,McCoy,Uhur ...
- Created on 08 December 2014
- 5. How to Java programming in Oracle Database
- (Java)
- ... result is, that a Oracle version 11.2, which is very common right now (the first release dates from 2007), has the Java Runtime version 1.5.0_10 (2005!) included. The entire source code of the director ...
- Created on 07 December 2014
- 6. Oracle Goodies for XML and JSON
- (PL/SQL)
- ... y the data to see what we have: SQL> select * from ex01_person_tb; ID NAME ---------- -------------------------------------------------- 1 Roger Waters 2 David Gilmo ...
- Created on 27 September 2014
- 7. 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
- 8. me
- (Uncategorised)
- ... Karlsruhe from 1992-95 Apprenticeship to Software Developer from 1988-1990 (Degree: Organisationsprogrammierer IHK) Technologies and Skills: Oracle SQL, PL/SQL, APEX, Java, J2EE, C++, PeopleSoft, ...
- Created on 14 October 2012
Visits
Today 46 | Week 225 | Month 843 | All 1149596
Latest Articles
Most Popular Articles last 24h
Most Popular Articles last Week
Popular Tags
Challenges Completed
StackOverflow
