全是我自己做的笔记,供大家一起分享和探讨

一次，他在核实数据时，认为部分数据需要重新测量，但项目部的车都被派出去了。belimitedtonomorethan2daysofwork,materialdepositedinspecialinsulatedcontainers,materialhandlingtogentlyandmakeuseofthermalinsulationmaterialinwindproof,waterproof,moisture-proofmeasure.6.2thermaldesignoptimizationforhigh-temperaturespecialthermalinsulationforpipingsupportandhangerdesign,reducedheatdissipationofthehangers,ensurethatthewalldoesnotoverheat.Small-diameterpiping,thermalinstrumentlayoutandpositioningofsupportandhangerdesigntakefullyintoaccounttheexpansionspaceandinsulationthickness.Large-diameterpipesafterheatpreservationplasteringconstructionofvalves,turbine,checkingsmoothsurface,hightemperaturepowderpaintfullydryafter.Protectivecoveringsforelectricequipmentinsulationboardsdesignedwithpressureplate,whenorderingaccordingtotheinstallationdiagram,modelspecificationspublishingorder,ensurewheninstallingcornersneat,uniformappearance,reducetheamountofon-sitemachining.Beforevalves,flangeinsulationshellconstruction,besuretomakeaunifiedmodel,allvalves,flanges,insulationcoverunified,tidyandbeautiful.Whenfourpartssuchaspipes,boilerinsulation,mustdofirstarticleinspection,proofofdesignandconstructionmethods,technologycanmeetthetechnologicalrequirements,beforeextensiveconstruction.Boilersteelbeams,dooropeningboxesdesignedwithinsulationgaskets,flangecannotbeoblique,evenfastened.Backintotheslopeofthetubingduringinstallationpayattentiontothepiping,oilstationisalowpoint.Refuelingmustbecontrolledwhencastingmaterialparts,selectlowthermalconductivitymaterialsasfaraspossible,ensurethatthesepartsdonotoverheat.6.3qualitydefectsofinsulationtechnologymanagementoptimizationofconstructionprocessanddevelopareasonableduration,regionaltransferofstrictly全是我自己做的笔记,供大家一起分享和探讨.txt台湾一日不收复，我一日不过4级！如果太阳不出来了，我就不去上班了；如果出来了，我就继续睡觉！全是我自己做的笔记，供大家一起分享和探讨：第一课：客户端1.Dos命令行下：sqlplus用户名：scott密码：tiger,sqlplusscott/tiger2.开始－运行－sqlplus图形版的SQLPLUS3.:管理PlsqlDeveloper第二课：更改用户1.sqlplussys/bjsxtassysdba2.alteruserscottaccountunlock;(解锁)第三课：table_structures1.desc表名2.select*from表名第四课：select语句1.selectename,sal*12annual_salfromemp;selectenamesal*12annualsalfromemp;双引号可以保持原大小写，并且中间可以加空格，不加全变为大写2.descdual，select2*3fromdual，dual是系统自带的一张空表，计算数据时可以使用该表3.任何含有空值的算术表达式的计算结果是空值4.selectename||salfromemp;5.selectename||'abcdefg'fromemp;6.selectename||'abcd''efg'fromemp;当字符串中含有单引号时，可用两个单引号代表一个单引号7.setlinesize200;--用于设定每行显示的宽度8.setpagesize30;--设置显示的页数第五课：distinct1.selectdistinctdeptnofromemp;2.selectdistinctdeptno,jobfromemp;第六课：where1.select*fromempwhereempno=10;2.select*fromempwhereempno10;3.select*fromempwhereename='hebe';4.select*fromempwheresal(not)between800and1500;5.select*fromempwherecommis(not)null;6.select*fromempwhereename(not)in('smith','philip','jay');7.select*fromempwhereenamelike'_A%';8.select*fromempwhereenamelike'_\%a%';系统默认转义符是\,可以自己指定转一次，他在核实数据时，认为部分数据需要重新测量，但项目部的车都被派出去了。belimitedtonomorethan2daysofwork,materialdepositedinspecialinsulatedcontainers,materialhandlingtogentlyandmakeuseofthermalinsulationmaterialinwindproof,waterproof,moisture-proofmeasure.6.2thermaldesignoptimizationforhigh-temperaturespecialthermalinsulationforpipingsupportandhangerdesign,reducedheatdissipationofthehangers,ensurethatthewalldoesnotoverheat.Small-diameterpiping,thermalinstrumentlayoutandpositioningofsupportandhangerdesigntakefullyintoaccounttheexpansionspaceandinsulationthickness.Large-diameterpipesafterheatpreservationplasteringconstructionofvalves,turbine,checkingsmoothsurface,hightemperaturepowderpaintfullydryafter.Protectivecoveringsforelectricequipmentinsulationboardsdesignedwithpressureplate,whenorderingaccordingtotheinstallationdiagram,modelspecificationspublishingorder,ensurewheninstallingcornersneat,uniformappearance,reducetheamountofon-sitemachining.Beforevalves,flangeinsulationshellconstruction,besuretomakeaunifiedmodel,allvalves,flanges,insulationcoverunified,tidyandbeautiful.Whenfourpartssuchaspipes,boilerinsulation,mustdofirstarticleinspection,proofofdesignandconstructionmethods,technologycanmeetthetechnologicalrequirements,beforeextensiveconstruction.Boilersteelbeams,dooropeningboxesdesignedwithinsulationgaskets,flangecannotbeoblique,evenfastened.Backintotheslopeofthetubingduringinstallationpayattentiontothepiping,oilstationisalowpoint.Refuelingmustbecontrolledwhencastingmaterialparts,selectlowthermalconductivitymaterialsasfaraspossible,ensurethatthesepartsdonotoverheat.6.3qualitydefectsofinsulationtechnologymanagementoptimizationofconstructionprocessanddevelopareasonableduration,regionaltransferofstrictly义符select*fromempwhereenamelike'_$%a%'escape'$';第七课：orderby1.select*fromdept;2.select*fromdeptorderbydeptdesc;(默认为asc)3.selectename,sal,deptnofromempwheresal2000orderbydeptnoasc,enamedesc;第八课：sql_function1.selectename,sal*12annual_salfromempwhereenamenotlike'_A%'andsal1500orderbysaldesc;2.selectlower(ename)fromemp;3.selectenamefromempwherelower(ename)like'_a%';4.selectsubstr(ename,2,3)fromemp;从第二字符截，一共截三个字符。5.selectchr(65)fromdual;结果为A6.selectascii('a')fromdual;结果为657.selectround(3