Oracle version:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0
PL/SQL Release 12.2.0.1.0 - Production 0
"CORE 12.2.0.1.0 Production" 0
TNS for Linux: Version 12.2.0.1.0 - Production 0
NLSRTL Version 12.2.0.1.0 - Production 0
I am running below query. its workin fine when i pull columns from v7 table
SELECT
V7.NAME
FROM bmc_core_bmc_operatingsystem@PRODITAMRV7_LINK v7
WHERE v7.classid = 'BMC_OPERATINGSYSTEM'
AND v7.datasetId = 'BMC.ASSET'
AND v7.Name IN
(SELECT v9.name
FROM ast_operatingsystem v9
WHERE v9.RECONCILIATION_IDENTITY !='0'
AND v9.class_id = 'BMC_OPERATINGSYSTEM'
AND v7.AssetLifecycleStatus <> v9.AssetLifecycleStatus
) ;
how to fetch columns from v9 table as well like below
SELECT
V7.NAME,V9.NAME,V7.CLASSID, V9.CLASS_ID
FROM bmc_core_bmc_operatingsystem@PRODITAMRV7_LINK v7
WHERE v7.classid = 'BMC_OPERATINGSYSTEM'
AND v7.datasetId = 'BMC.ASSET'
AND v7.Name IN
(SELECT v9.name
FROM ast_operatingsystem v9
WHERE v9.RECONCILIATION_IDENTITY !='0'
AND v9.class_id = 'BMC_OPERATINGSYSTEM'
AND v7.AssetLifecycleStatus <> v9.AssetLifecycleStatus
) ;
Thanks.