数据库中间表删除步骤

1、中间表数据删除，口令：111111选择 My objectsiH.步，+ + + + + + + + + + + + + + + + + + + + + + + + + +1 PL/SQL Developer - tgl:文件虞）工程。褊辑 会话匿k：My ubjects回收站FuiLcti orisFr u c h dm- p sPackagesPackage bndi ps TypqTyp已 b o di h sTriggersJava s um- c e sJ obsQuhUPSQuhup t ablh sLi t* ar i 奖Direct ori psTablhsVi hwsM at

2、 er i ：1 i z h d vi ewsS h QilPnC P sUser sFrutilesRulesSjTLurLjTTi sDatabase linksTablhspaces Clusters第二步:展开 Tables ,单击右键YSD,编辑数据Tablee点击实例查询FEDFERTIE 如 FiRNFIGURATUKTEMFFLAN TABLEFRDDEFECTMateri Sequen IJsersFrofilRules Sj-TLuny D a tab a Tablee Cluste新建复制. 刷新逗号分隔复制属性描述查看编辑重命名册瞠洌览重新编译参照对象DBMS_Meta

3、data查询数据编辑数据导出数据添加到文件夹击SQL宦口二编辑table YSMKFGL的数据匚|回区|SQL|输出|统计表el e c t t. * , t. rowi d fr om ysd t同，邑+ - 乎受盹 a 摹耐昌通，SFZH| MATHR| MAKTXLGORTDGOBE|PEACELFH|WIDTHLENGTHTHICK |WEIGHT |VEELNA1MD-4E日LN 661101011400100002 T曜轧冷硬卷CQ/SPCC/1400mm* 1. OmmP. 101545碳钢冷轧成品库判废MD-4E月口140021161.0022.89029A0575LA -6B

4、1101011300120002TL酸轧冷硬卷CQ/SFCC/1300mm* 1.2mm6101545碳钢冷轧成品库合格9AO575IA 13003071.203.72039A0105LH -6B1102011400070002冷硬卷DQ/SPCD/1400mm*0. 7mm6101545碳钢冷轧成品库合格9A0105Ltf -140030210.7022.93049A0260LH -6B1102011530180002TL酸如冷硬卷DQ/SPCD/1530mm*l. 8mm6101545碳钢冷轧成品库合格9A0260LU -153012401.8026.68059A0326UT -6B110

5、2011530180002TL$L冷硬卷DQ/SPCD/1530mm* 1.8mm6101545碳钢冷轧成品库合格9A0326LU -153012401.8026.64069A0109LN -6B1102011400070002TL酸牝冷硬卷DQ/SPCD/1400mm*0. 7mm6101545碳钢冷轧成品库合格9AJ0109LK -140030230.7023.08079A0580LE：-6B110101140011：10002TL蠢车冷硬卷 CQ/SPCC/1400mm* l.OmmF. 101545碳钢冷轧成品库合格gA058i：iU：-140010121.0011.08089A011

6、1LN6B1102011400070002TL酸虬冷硬卷DQ/SFCD/1400mm*0. Tmm6101545碳钢冷轧成品库合格9A0111L2T140030560.7023.32099A0U8LN -6B1101011400070002TL酸车冷硬卷CQ/SPCC/1400mm*0. 7mm6101545碳钢冷轧成品库9A0118L2T -140030630.7023.420109A0472LA -6B1101011400100002TL$L 冷硬卷 CQ/SFCC/1400mm*1.0mm6101545碳钢冷轧成品库9AO472IA14008751.009.580119A0107LN -

7、6B1102011400070002TLg如冷硬卷DQ/SFCD/1400mm*0. 7mm6101545碳钢冷轧成品库9A0107Lff -140030800.7023.490129A0581LB -6B1101011400100002TL酸瓦冷硬卷CQ/SPCC/1400mm* 1.0mm6101545碳钢冷轧成品库9A058m： -14008651.009.470139A0578LB -6B110101140011：10002冷硬卷CQ/SPCC/1400mm*l. 0mm6101545碳钢冷轧成品库9A0578m -14008761.009. 600149A0446LN -6B1102

8、011530100002TL酸如冷硬卷DQ/SPCD/1530mm*l. 0mm6101545碳钢冷轧成品库9A0446LU -153022921.0027.410159A0466LN -6B1101011530070002TI如冷硬卷CQ/SPCC/1530mm*0. Tmm6101545碳钢冷轧成品库9A0466LK -153031190.7026. 963169A0113LN -6B1102011400070002TL酸轧冷硬卷DQ/SFCD/1400mm*0. Tmm6101545碳钢冷轧成品库合格9A0113LW -140030430.7023. 190179A0122LN -6B1

9、101011400070002TL酸轧冷硬卷CQ/SPCC/1400mm*0. 7mm6101545碳钢冷轧成品库合格9A0122LW -140030570.7023.370189A0456LN -6B1102011530100002TL蠢车冷硬卷 DQ/SFCD/1530mm*1.0mm6101545碳钢冷轧成品库-合格9A0456LW -15308731.0010.430Y否1:12。行被选择，耗时D. 1Q9秒 便多.)第四步，输入检验批次，例如：1B8626LNPB+ -MSFZHMATNKMAKTX1B8626LHPB -来第五步，点击实例查询傩SFZHMATNJLMAKTXLiXiRTLGOBEFFACELFHWIDTHLENGTHTHICKWEIGHTVBEIJ1liBQ&zeu