tnsping komutu

Örnek

Şöyle yaparız

$ tnsping CUST2DB

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 30-MAR-2022 03:25:26

Copyright (c) 1997, 2016, Oracle.  All rights reserved.

Used parameter files:
/export/home/oracle/products/12.2.0.1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = corelan-3-scanvip)
(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CUST2DB)))
OK (0 msec)

MINUS Operator

Örnek

Şöyle yaparız

SELECT 'FirstPart' FROM mytable t
MINUS
SELECT'FirstPart', FROM myothertable t;