数据库设计学习

select * from wtpartmaster ;

select * from wtpartmaster where ida2a2 = 611205;

select * from wtpart where IDA3MASTERREFERENCE = 611205;

select * from wtpartusagelink where ida3b5 = 611205;

select * from WTTYPEDEFINITION where ida2a2 = 1493;

select  IDA3MASTERREFERENCE from WTTYPEDEFINITION where ida2a2 = 1493;

select IDA3DOMAINREF from WTTYPEDEFINITION where ida2a2 = 1493;

select * from WTTYPEDEFINITIONMaster where ida2a2 = 1488;

select * from ADMINISTRATIVEDOMAIN where ida2a2=7;

select * from STRINGDEFINITION ;

select * from STRINGDEFINITION where IDA3DOMAINREF = 7;

select distinct(CLASSNAMEKEYA4) from STRINGVALUE where rownum<10000;

-- 在表中查询 特定类型零件的 数据
select * from STRINGVALUE where  CLASSNAMEKEYA4 = 'wt.part.WTPart' and ida3a4 = 475862 and  rownum<100;

select * from STRINGDEFINITION where ida2a2 = 133032;

select * from STRINGDEFINITION where ida2a2 = 20629;

select * from wtpart where ida2a2 = 475862;