非常感谢.
对于两表中的某一字段进行查询,
但这两表没有确定的关联,只有一个字段中的内容有相似可比处,建立关联查询.
但查询结果不能令人满意.
表1:yy_sybm_temp
create table COMM.YY_SYBM_TEMP
(
INSURANCE_PRICE_ITEM_CODE VARCHAR2(20) not null,
SPELL_CODE VARCHAR2(100),
PHYSIC_NAME VARCHAR2(400),
FORM VARCHAR2(100),
REFERENCE_PERCENT NUMBER(6),
MEMO VARCHAR2(4000),
INSURANCE_CLASS CHAR(8),
CHEMISTRY_NAME VARCHAR2(400),
CHEMISTRY_SPELL_CODE VARCHAR2(100),
GENERAL_NAME VARCHAR2(400),
GENERAL_SPELL_CODE VARCHAR2(100),
ENGLISH_NAME VARCHAR2(400),
ENGLISH_SPELL_CODE VARCHAR2(100)
)
表2 physic_dict_table_temp
create table COMM.PHYSIC_DICT_TABLE_TEMP
(
PHYSIC_CODE VARCHAR2(14),
PHYSIC_NO VARCHAR2(100),
PHYSIC_STANDARD_CODE VARCHAR2(16),
PHYSIC_NAME_CODE VARCHAR2(10),
PHYSIC_NAME VARCHAR2(400),
PHYSIC_SPEC VARCHAR2(200),
PHYSIC_UNIT VARCHAR2(8),
MIN_DOSE NUMBER(8,3),
DOSE_UNIT VARCHAR2(8),
PACK_UNIT VARCHAR2(8),
PACK_SPEC NUMBER(12,2),
TRADE_PRICE NUMBER(15,6),
RETAIL_PRICE NUMBER(15,6),
FORM VARCHAR2(10),
TOXICOLOGY_PROPERTY VARCHAR2(10),
MATERIAL_PROPERTY VARCHAR2(10),
MONEY_PROPERTY VARCHAR2(10),
MEDICINALLY_PART VARCHAR2(10),
TRAGACANTH_PROPERTY VARCHAR2(10),
MANAGER_PROPERTY VARCHAR2(10),
MANAGER_MATERIAL VARCHAR2(10),
REGISTER_DATE DATE,
UNTUCK_FLAG CHAR(1),
PACK_UNTUCK CHAR(1),
PACK_UNTUCK_RESI CHAR(1),
MEDICARE_FLAG CHAR(1),
CHECK_FORM VARCHAR2(4),
FORM_FLAG CHAR(1),
FREQUENCY VARCHAR2(3),
DOSEAGE NUMBER(8,3),
MAX_DOSEAGE NUMBER(8,3),
USAGE VARCHAR2(10),
DAY_COUNT NUMBER(3,1),
SPECIAL_FLAG CHAR(1),
ALLOW_OWE CHAR(1),
ITEM_ON_DISPENSARY_RECEIPT VARCHAR2(4),
ITEM_ON_RESIDENT_RECEIPT VARCHAR2(4),
ITEM_ON_CASE_OUTLAY VARCHAR2(4),
ITEM_ON_DEPT_STATS VARCHAR2(4),
ITEM_ON_TREASURER_SUBJECT VARCHAR2(4),
MEMO VARCHAR2(4000),
SKIN_TYPE VARCHAR2(2),
REGISTER_DEPT VARCHAR2(8),
PRESCRIPTION_FLAG CHAR(1),
INCREASE_RATE NUMBER(6,2),
SUPPLIER VARCHAR2(10),
FACTORY_CODE VARCHAR2(10),
MAX_DAYS INTEGER,
MAX_SUM NUMBER(9,2),
PUBLIC_FLAG CHAR(1),
GMP_FLAG CHAR(1),
PUBLIC_PRICE NUMBER(15,4),
SPECIAL_PRICE NUMBER(15,4),
NO_CARD_MAX_DOSAGE NUMBER(9,2),
NO_CARD_MAX_DAYS NUMBER(3,1),
NO_CARD_MAX_SUM NUMBER(9,2),
NO_CARD_MAX_FREQUEC VARCHAR2(3),
CARD_MAX_DOSAGE NUMBER(9,2),
CARD_MAX_DAYS NUMBER(3,1),
CARD_MAX_SUM NUMBER(9,2),
CARD_MAX_FREQUEC VARCHAR2(3),
INSURANCE_FLAG CHAR(1),
OLD_TRADE_PRICE NUMBER(15,6),
OLD_RETAIL_PRICE NUMBER(15,6),
IMPORT_PRICE NUMBER(15,6),
OLD_SUPPLIER VARCHAR2(10),
OLD_FACTORY_CODE VARCHAR2(10),
PHYSIC_STANDARD_SPEC VARCHAR2(200),
CUSTOM_FLAG CHAR(1),
CHEMISTRY_NAME VARCHAR2(400),
GENERAL_NAME VARCHAR2(400),
ENGLISH_NAME VARCHAR2(400),
CHEMISTRY_SPELL_CODE VARCHAR2(100),
COUNTRY_PHYSIC_LIST CHAR(1),
CHECK_NO VARCHAR2(100),
MAX_RETAIL_PRICE NUMBER(15,6),
PUBLIC_SEQ VARCHAR2(20),
INSURANCE_CLASS CHAR(1),
SPELL_CODE VARCHAR2(100),
PRINT_FORM VARCHAR2(2),
PRINT_FORM_KIND VARCHAR2(2),
INJ_PLACE CHAR(1),
MARK_TIMES NUMBER(5),
RESI_DEFAULT_DOSEAGE NUMBER(8,3),
RESI_DEFAULT_FREQUENCY VARCHAR2(3),
RESI_DEFAULT_DAY_COUNT NUMBER(3,1),
RESI_DEFAULT_USAGE VARCHAR2(10),
DOSEAGE_UNIT VARCHAR2(8),
RESI_DEFAULT_DOSEAGE_UNIT VARCHAR2(8),
MAX_DOSEAGE_UNIT VARCHAR2(8),
NO_CARD_MAX_DOSEAGE_UNIT VARCHAR2(8),
CARD_MAX_DOSEAGE_UNIT VARCHAR2(8)
)
现要将表2的PHYSIC_CODE在表1中建立,与表1的INSURANCE_PRICE_ITEM_CODE对应起来.
两表中只有PHYSIC_NAME可以建立关联条件,但PHYSIC_NAME内容不是完全相等或精确的.只能是相似.所以要建立此相似的关系,不知如何操作.使之表2的PHYSIC_CODE与表1的INSURANCE_PRICE_ITEM_CODE对应起来.