I have created a table in Oracle. I then update that table by an INSERT INTO statement. When I link the table to MS Access, it does not retain the Oracle table properties. Am I doing something incorrect when I insert the data? Here is the SQL:
INSERT INTO NETREVMODQ
SELECT DISTINCT VISIT_CHARGES.SITE_ID,
VISIT_CHARGES.FACILITY_ID,
INSURANCE_MASTER.ENTITY,
MST_CHARGES.GL_DEPT,
VISIT_CHARGES.CHARGE_NO,
MST_CHARGES.CHARGE_DESC,
VISITS.PATIENT_CLASS,
INSURANCE_MASTER.PAYOR,
INSURANCE_MASTER.PAYOR_DESCRIPTION,
SUM (VISIT_CHARGES.CHARGE_QTY) AS QTY,
SUM (VISIT_CHARGES.CHARGE_AMT) AS CHRGS,
VISIT_CHARGES.REV_CODE
FROM (((FIN.VISIT_CHARGES VISIT_CHARGES
INNER JOIN FIN.MST_CHARGES MST_CHARGES
ON (VISIT_CHARGES.SITE_ID = MST_CHARGES.SITE_ID)
AND (VISIT_CHARGES.CHARGE_NO = MST_CHARGES.CHARGE_NO))
INNER JOIN FIN.VISITS VISITS
ON (VISIT_CHARGES.SITE_ID = VISITS.SITE_ID)
AND (VISIT_CHARGES.ACCOUNT_NO = VISITS.ACCOUNT_NO)
AND (VISIT_CHARGES.FACILITY_ID = VISITS.FACILITY_ID))
INNER JOIN FIN.VISIT_INSURANCE VISIT_INSURANCE
ON (VISIT_INSURANCE.SITE_ID = VISITS.SITE_ID)
AND (VISIT_INSURANCE.ACCOUNT_NO = VISITS.ACCOUNT_NO)
AND (VISIT_INSURANCE.FACILITY_ID = VISITS.FACILITY_ID))
INNER JOIN EDW.INSURANCE_MASTER INSURANCE_MASTER
ON (VISIT_INSURANCE.FACILITY_ID = INSURANCE_MASTER.EDW_ID)
AND (VISIT_INSURANCE.INSURANCE_CODE =
INSURANCE_MASTER.INSURANCE_CODE)
WHERE (VISIT_INSURANCE.INSURANCE_SEQ = 1)
AND (VISITS.DISCHARGE_DATE BETWEEN TO_DATE (‘2014-07-01 00:00:00’,
‘yyyy/mm/dd hh24:mi:ss’)
AND TO_DATE (‘2014-12-31 00:00:00’,
‘yyyy/mm/dd hh24:mi:ss’))
AND (VISIT_CHARGES.POSTING_DATE BETWEEN TO_DATE (
‘2014-07-01 00:00:00’,
‘yyyy/mm/dd hh24:mi:ss’