Oracle大总结TOC\o"1-3"\h\z\uHYPERLINK\l"_Toc295159560"第一章数据库简介PAGEREF_Toc295159560\h2HYPERLINK\l"_Toc295159561"1.1数据库的种类PAGEREF_Toc295159561\h2HYPERLINK\l"_Toc295159562"1.1.1数据库产品PAGEREF_Toc295159562\h2HYPERLINK\l"_Toc295159563"1.1.2数据库PAGEREF_Toc295159563\h2HYPERLINK\l"_Toc295159564"1.1.3连接数据库PAGEREF_Toc295159564\h2HYPERLINK\l"_Toc295159565"1.1.4数据库语法PAGEREF_Toc295159565\h3HYPERLINK\l"_Toc295159566"第二章结构化查询语言(SQL)PAGEREF_Toc295159566\h3HYPERLINK\l"_Toc295159567"2.1结构化查询语言(SQL)PAGEREF_Toc295159567\h3HYPERLINK\l"_Toc295159568"2.1.1SQL(脚本script)PAGEREF_Toc295159568\h3HYPERLINK\l"_Toc295159569"2.2数据定义语言(DDL(DataDefinationLanguage))PAGEREF_Toc295159569\h4HYPERLINK\l"_Toc295159570"2.2.1createPAGEREF_Toc295159570\h4HYPERLINK\l"_Toc295159571"2.2.2dropPAGEREF_Toc295159571\h4HYPERLINK\l"_Toc295159572"2.2.3alterPAGEREF_Toc295159572\h4HYPERLINK\l"_Toc295159573"2.2.4rename…to…PAGEREF_Toc295159573\h4HYPERLINK\l"_Toc295159574"2.3数据操作语言(DML(DataManipulationLanguage))PAGEREF_Toc295159574\h4HYPERLINK\l"_Toc295159575"2.3.1insertPAGEREF_Toc295159575\h5HYPERLINK\l"_Toc295159576"2.3.2updatePAGEREF_Toc295159576\h5HYPERLINK\l"_Toc295159577"2.3.4deletePAGEREF_Toc295159577\h5HYPERLINK\l"_Toc295159578"2.4数据查询语言(DQL(DataQueryLanguage))PAGEREF_Toc295159578\h5HYPERLINK\l"_Toc295159579"2.4.1selectPAGEREF_Toc295159579\h6HYPERLINK\l"_Toc295159580"2.4.2条件语句(where,and,or)PAGEREF_Toc295159580\h6HYPERLINK\l"_Toc295159581"2.4.3null,in,any,allPAGEREF_Toc295159581\h6HYPERLINK\l"_Toc295159582"2.4.4between...and闭区间PAGEREF_Toc295159582\h6HYPERLINK\l"_Toc295159583"2.4.5like:模糊查询PAGEREF_Toc295159583\h7HYPERLINK\l"_Toc295159584"2.4.6排序orderbyPAGEREF_Toc295159584\h7HYPERLINK\l"_Toc295159585"2.4.7不重复的distinctPAGEREF_Toc295159585\h7HYPERLINK\l"_Toc295159586"2.4.8groupby分组PAGEREF_Toc295159586\h7