Oracle DB Link records

Method 1: Write the oracle db link by code; create public database link test_link2 connect to twc identified by twc using '(description = (address_list = (address = (protocol = TCP) (HOST = 192.168.0.129) (PORT = 1521) (connect_data = (service_name = LHW) '; select * from twc. sfzinfo @ test_link2; Note: test_link2 is the dblink name, twc/twc is the oracle database -www.2cto.com-user name and password, HOST is the IP address of the remote database, and PORT is the database PORT number, service_name is the name of the Datebase server. Method 2: It is written through PL/SQL. It has been written before and will not be described. The author tanwencan