https://blog.youkuaiyun.com/chen3512786zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/chen3512786/article/details/5337784https://blog.youkuaiyun.com/chen3512786/article/details/5337784chen3512786Tue, 02 Mar 2010 10:02:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/5273985https://blog.youkuaiyun.com/chen3512786/article/details/5273985chen3512786Sun, 31 Jan 2010 08:47:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/5273973https://blog.youkuaiyun.com/chen3512786/article/details/5273973chen3512786Sun, 31 Jan 2010 08:32:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/5258021https://blog.youkuaiyun.com/chen3512786/article/details/5258021chen3512786Tue, 26 Jan 2010 14:59:00 +0800.NUMBER类型细讲：Oracle number datatype 语法：NUMBER[(precision [, scale])]简称：precision --> p      scale     --> sNUMBER(p, s)范围： 1 保存数据范围：-1.0e-130 保存在机器内部的范围： 1 ~ 22 bytes有效为：从左边第一个不为0的数算起的位数。s的情况：s > 0  ]]>https://blog.youkuaiyun.com/chen3512786/article/details/5251860https://blog.youkuaiyun.com/chen3512786/article/details/5251860chen3512786Sun, 24 Jan 2010 22:16:00 +0800 create table a as select rownum a from t where rownum < 100;　　表已创建。　　SQL> alter table a initrans 5;　　表已更改。　　SQL> update a set a = 100 where a in (1,3,5,7,9);　　已更新5行。　　SQL> alter system dum]]>https://blog.youkuaiyun.com/chen3512786/article/details/5251797https://blog.youkuaiyun.com/chen3512786/article/details/5251797chen3512786Sun, 24 Jan 2010 21:46:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/5150304https://blog.youkuaiyun.com/chen3512786/article/details/5150304chen3512786Thu, 07 Jan 2010 14:17:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/5148400https://blog.youkuaiyun.com/chen3512786/article/details/5148400chen3512786Thu, 07 Jan 2010 10:23:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/4176828https://blog.youkuaiyun.com/chen3512786/article/details/4176828chen3512786Wed, 13 May 2009 13:34:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/4176683https://blog.youkuaiyun.com/chen3512786/article/details/4176683chen3512786Wed, 13 May 2009 12:56:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/4176669https://blog.youkuaiyun.com/chen3512786/article/details/4176669chen3512786Wed, 13 May 2009 12:52:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/4176657https://blog.youkuaiyun.com/chen3512786/article/details/4176657chen3512786Wed, 13 May 2009 12:50:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/4176655https://blog.youkuaiyun.com/chen3512786/article/details/4176655chen3512786Wed, 13 May 2009 12:50:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/4176651https://blog.youkuaiyun.com/chen3512786/article/details/4176651chen3512786Wed, 13 May 2009 12:49:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/4176558https://blog.youkuaiyun.com/chen3512786/article/details/4176558chen3512786Wed, 13 May 2009 12:32:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/4176441https://blog.youkuaiyun.com/chen3512786/article/details/4176441chen3512786Wed, 13 May 2009 12:03:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/3257077https://blog.youkuaiyun.com/chen3512786/article/details/3257077chen3512786Sat, 08 Nov 2008 23:24:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/3257069https://blog.youkuaiyun.com/chen3512786/article/details/3257069chen3512786Sat, 08 Nov 2008 23:22:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/3241903https://blog.youkuaiyun.com/chen3512786/article/details/3241903chen3512786Thu, 06 Nov 2008 22:36:00 +0800https://blog.youkuaiyun.com/chen3512786/article/details/3241474https://blog.youkuaiyun.com/chen3512786/article/details/3241474chen3512786Thu, 06 Nov 2008 21:42:00 +0800