DB, SERVER/ORACLE
외부 데이터베이스(레거시) 접근
atlasia
2018. 4. 17. 15:07
--CREATE PUBLIC DATABASE LINK DATALINK2
-- CONNECT TO XXXXXX(ACCOUNT NAME)
-- IDENTIFIED BY "XXXXXX"
-- USING'(DESCRIPTION =
-- (
-- ADDRESS_LIST =
-- (
-- ADDRESS = (PROTOCOL = TCP) (HOST=255.255.255.255)(PORT = 1521)
-- )
-- )
-- (CONNECT_DATA = (SERVICE_NAME = XE)
-- )
-- )'
--
--
--SELECT COUNT(*) FROM TABLE_NAME@DATALINK2;