CREATE DATABASE LINK <DB_LINK_NAME>
CONNECT TO <SCHEMA> IDENTIFIED BY <PASSWORD>
USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = <HOST>) (PORT = <PORT>))) (CONNECT_DATA = (SERVICE_NAME = <SERVICE_NAME>)))';Related Links:
top of page
Related Posts
See AllExample 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...
FUNCTION Strip_Ora_Error ( sqlerrm_ IN VARCHAR2, sqlcode_ IN NUMBER DEFAULT NULL, strip_ora_only_ IN BOOLEAN DEFAULT...
Example 1: SELECT handling_unit_id, t.shipment_id FROM handling_unit_tab t START WITH handling_unit_id = '4558' CONNECT BY PRIOR...
bottom of page
Comments