May 2018
Intermediate to advanced
576 pages
30h 25m
English
Here, we provide stepwise instructions on how to connect to an Oracle server using oracle_fdw:
CREATE EXTENSION IF NOT EXISTS oracle_fdw;
CREATE SERVER myserv FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver '//myhost/MYDB'); CREATE USER MAPPING FOR myuser SERVER myserv;
CREATE FOREIGN TABLE mytab(id bigint, descr text) SERVER myserv OPTIONS (user 'scott', password 'tiger');
INSERT INTO mytab VALUES (-1, 'Minus One');