NC 数据库操作常用备忘

1.查询某个元数据所有实现接口

select distinct fullclassname from md_class where  classtype=206 and id in (select distinct bizInterfaceID from md_bizitfmap where classid ='md_class表中的ID字段值');

2.查询主子查询接口的SQL
select * from md_bizitfmap t where t.bizinterfaceid='md_class表中的ID字段值';

3.后台UI主界面配置的先关参数表

sm_paramregister

4.消息类型表

sm_msg_msgtype

5.同步两个表数据

第一步.建立dblink

create public database link standardbase

 connect to nc636_standard_0211 identified by "1"

 using '(DESCRIPTION =

   (ADDRESS = (PROTOCOL = TCP)(HOST = 20.10.129.87)(PORT = 1524))

   (CONNECT_DATA =

     (SERVER = DEDICATED)

     (SERVICE_NAME = ora11g)

    )

  )';

第二步.插入需要同步的数据

insertinto tb_md_excelfile @standardbase select * from tb_md_excelfile t where  t.pk_obj='0001ZA10000000003A7Q'