淘宝网开发人员数据库知识参考手册淘宝网开发技术人员数据库知识参考手册（V2.0）--胜通编写、修订、审核记录编号文档版本修订章节修订原因修订日期修订人11.0全文新建文档2007-9-27胜通22.0补充文档2008-1-6胜通3456789101淘宝网开发技术人员数据库知识参考手册（V2.0）--胜通目录第一章基本元素.....................................................................................................................................6第一节数据类型.................................................................................................................................61.VARCHAR2（size）：.............................................................................................................62.CHAR（size）..........................................................................................................................63.LONG........................................................................................................................................74.CLOB........................................................................................................................................75.NUMBER（p，s）...................................................................................................................76.DATE.........................................................................................................................................87.TIMESTAMP（factional_seconds_precision）.....................................................................8第二节NULL.......................................................................................................................................8第三节伪列.......................................................................................................................................111.CURRVAL和NEXTVAL........................................................................................................112.LEVEL.....................................................................................................................................123.ROWID....................................................................................................................................124.ROWNUM...............................................................................................................................135.XMLDATA...............................................................................................................................15第四节注释.......................................................................................................................................15第五节数据库的对象.......................................................................................................................161.模式对象.................................................................................................................................162.非模式对象.............................................................................................................................173.部分模式对象.........................................................................................................................17第六节格式模型...............................................................................................................................171.时间格式........
