1. Using PLSQL tools to connect to the local database, create dblink database information, can connect @ ISC_150_1 limited (direct)
Use statement select * from isc_user @ ISC_150_1 can query data information,

Question: would you like to use the following statement execution, export to specify data table, don't know where to join @ ISC_150_1, great god, please give directions,

The SELECT P.B USI_ITEM_CODE,
O.org _name,
Substr (P.C ONS_ORG_NO, 1, 7),
P.C ONS_NO,
P.C ONS_NAME,
P. ARKETING_APP_NO
The FROM (select DISTINCT T.M ARKETING_APP_NO,
Tc ONS_ORG_NO,
T.B USI_ITEM_CODE,
Tc ONS_NO,
Tc ons_Name
The from FA_BUS_INF t, FA_TASK K SP_WF_WORKLIST_COM M
WHERE T.T ASK_ID=K.T ASK_ID
AND K.W ORKITEM_ID=m. ORKITEM_ID
AND T.B USI_ITEM_CODE IN (' 101 ', '102', '103', '104', '111', '112')
AND M.C REATE_TIME & gt;=TO_DATE (' 2018-03 ', 'YYYY - MM)
AND M.C REATE_TIME & lt; TO_DATE (' 2018-04 ', 'YYYY - MM)
The union

Select DISTINCT T.M ARKETING_APP_NO,
Tc ONS_ORG_NO,
T.B USI_ITEM_CODE,
Tc ONS_NO,
Tc ons_Name
The from FA_BUS_INF_ARC t, FA_TASK_ARC K SP_WF_WORKLIST_HIS M
WHERE T.T ASK_ID=K.T ASK_ID
AND K.A PP_NO=m. PP_NO
AND T.B USI_ITEM_CODE IN (' 101 ', '102', '103', '104', '111', '112')
AND M.C REATE_TIME & gt;=TO_DATE (' 2018-03 ', 'YYYY - MM)
AND M.C REATE_TIME & lt; TO_DATE (' 2018-04 ', 'YYYY - MM)) P
Isc.
o_org oWhere substr (P.C ONS_ORG_NO, 1, 7)=o.org _no
The ORDER BY P.B USI_ITEM_CODE, o.org _name, substr (P.C ONS_ORG_NO, 1, 7)

CodePudding user response:

Which table is remote, which add @ ISC_150_1 after the table name

CodePudding user response:

Which object is used to remote library is behind the which object to add the DBLINK

CodePudding user response:

Move the cursor to the table name, press F4, each table name to try again, can't open the add @ ISC_150_1 behind, and then press F4 to check, at this time will be able to open the table