- 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 create an APEX Plugin ...
- (APEX)
- ... lng": 13.393611 } ]} ]} Step 1: Create the Plugin Plugins are managed within the Applicatin under the Shared Components. Here you can import any existing Plugin as well as c ...
- Created on 13 September 2014
- 3. How to handle Oracle BLOB columns via Database Link
- (Oracle)
- ... b where b.ID = a.ID ) AS BLOB_COLUMN FROM LOCAL_TABLE a; Solution 2: Pipelining Functions CREATE TYPE object_row_type AS OBJECT ( MYID NUMBER, MYCLOB CLOB ...
- Created on 05 October 2016
- 4. How to set manual locks to synchronize processes in Oracle
- (PL/SQL)
- ... a lock. Look at the following examples: create or replace package body my_package is [...] function lockSemaphore(pi_lock_name in varchar2, po_lock_result out number) ...
- Created on 18 November 2015
- 5. String Tokenizer with Oracle PL/SQL
- (PL/SQL)
- ... l function which splits a string in it's components: create or replace package itstar_toolbox is type t_tab_strings is table of varchar2(1000); [...] function split_string(pi_string in varcha ...
- Created on 08 December 2014
- 6. How to Java programming in Oracle Database
- (Java)
- ... ic class JavaOracleDemo { public static String hello (String name) { return ("Hello " + name); } } PL/SQL Wrapper Package: create or replace package DEMO_JAVA_WRAPPER is ...
- Created on 07 December 2014
- 7. Oracle Goodies for XML and JSON
- (PL/SQL)
- ... for the definition of the tables: create table ex01_person_tb ( id number, name varchar2(50) ); insert into ex01_person_tb values (1, 'Roger Waters'); insert into ex01_person_tb values (2, 'Dav ...
- Created on 27 September 2014