How does one perform the (+) connection in the Oracle database?

This article mainly introduces you to the actual operations of the (+) connection in the Oracle database. This article describes the actual operations using the relevant code, if you are a crazy group of (+) connections in Oracle databases, do not miss the following articles.

1. Slave Table A. A1 +) = Master Table B. B1

Copy code SELECT

 
 

  
  
TO_CHAR(TBA.FBS_IO_DATE,'YYYY/MM/DD') A1  
  
  
,TBA.TBA_TBD_NO A2  
  
  
,TBB.TBB_NAME_S A3  
  
  
,TBC.TBC_CHAR1 A4  
  
  
,TBD.TBD_NAME A5  
  
  
,TBA.TBA_SNS_NAME_SP A6  
  
  
,TBA.TBA_TORI_KIN A7  
  
  
,TO_CHAR(TBA.TBA_RPL_DATE,'YYYY/MM/DD') A8  
  
  
FROM  
  
  
SNTBATRN TBA  
  
  
,ZMTBCMST TBC  
  
  
,CMTBBMST TBB  
  
  
,CMTBDMST TBD  
  
  
WHERE  
  
  
TBA.TBA_KAI_CODE = 'XXX' 
  
  
AND TBA.TBA_KESHI_KBN = '0' 
  
  
AND TBA.TBA_TAISYO_KBN IN ('0', '2')  
  
  
AND TBB_KAI_CODE (+) = 'XXX'  
  
  
AND TBB_BUN_CODE (+) = 'S001'  
  
  
AND TBB_START_DATE <= SYSDATE  
  
  
AND TBB_END_DATE >= SYSDATE  
  
  
AND TBB.TBB_CODE (+)= TBA.TBA_STN_CODE  
  
  
AND TBC.TBC_KAI_CODE (+) = 'XXX'  
  
  
AND TBC.TBC_SUB_KBN (+) = 'SN'  
  
  
AND TBD.TBD_KAI_CODE (+) = 'XXX'  
  
  
AND TBD.TBD_CODE (+) = TBA.TBA_SNS_CODE   
 
 

2. Master Table A. A1 = slave Table B. B1 +)

 
 

  
  
Copy code
  
  
SELECT
  
  
Guid. TBA_1,
  
  
TBB. TBB_1,
  
  
TBC. TBC_1
  
  
FROM
  
  
Guid,
  
  
(Select tbb. TBB_1, TBB. TBB_2
  
  
FROM TBB
  
  
WHERE
  
  
TBB. TBB_3 LIKE '% NEWWEAPON %' TBB ),
  
  
TBC
  
  
WHERE
  
  
Master table TBC
  
  
Guid. TBA_A> 2
  
  
From table TBB
  
  
AND ga-. TBA_2 = TBB. TBB_2
  
  
Slave table TBC
  
  
Note TRIM
  
  
And trim (guid. TBA_3) = TRIM (TBC. TBC_3 (+ ))
 
 

The above content is an introduction to the (+) connection in the Oracle database. I hope you will have some gains.