SQLPL/SQL语法手册P2/73目录第一部分SQL语法部分....................................................................................................................................3一、CREATETABLE语句..............................................................................................................3二、CREATESEQUENCE语句.....................................................................................................5三、CREATEVIEW语句.................................................................................................................6四、INSERT语句:............................................................................................................................7五、UPDATE语句:...........................................................................................................................9六、DELETE语句:.........................................................................................................................10七、TRUNCATE语句:...................................................................................................................11八、各类FUNCTIONS:.................................................................................................................121.转换函数:................................................................................................122.日期函数.................................................................................................163.字符函数.................................................................................................204.数值函数.................................................................................................285.单行函数:................................................................................................336.多行函数.................................................................................................35第二部分PL/SQL语法部分...........................................................................................................................41一、PL/SQL语言简介....................................................................................................................41二、变量说明...................................................................................................................................48三、PL/SQL控制程序流................................................................................................................52四、存储过程...................................................................................................................................54五、存储函数...................................................................................................................................54六、PACKAGE................................................................................................................................54七、触发器.......................................................................................................................................56八、应用实例...................................................................................................................................5824-12-09P3/73第一部分SQL语法部分一、Createtable语句语句:CREATETABLE[schema.]table_name({columndatatype[DEFAULTexpr][column_constraint]...|table...
