<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[dengkai_java的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/dengkai_java</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; dengkai_java]]></copyright><item><title><![CDATA[oracle PROCEDURE 存储过程  ]]></title><link>https://blog.youkuaiyun.com/dengkai_java/article/details/5582649</link><guid>https://blog.youkuaiyun.com/dengkai_java/article/details/5582649</guid><author>dengkai_java</author><pubDate>Wed, 12 May 2010 14:47:00 +0800</pubDate><description><![CDATA[oracle 存储过程  1.基本结构 CREATE OR REPLACE PROCEDURE 存储过程名字 (     参数1 IN NUMBER,     参数2 IN NUMBER ) IS 变量1 INTEGER :=0; 变量2 DATE; BEGIN END 存储过程名字 2.SELECT INTO STATEMENT   将select查询的结果存入到变量中，可以同时将多个列存储]]></description><category></category></item><item><title><![CDATA[oracle 两个时间相减得 ]]></title><link>https://blog.youkuaiyun.com/dengkai_java/article/details/5156987</link><guid>https://blog.youkuaiyun.com/dengkai_java/article/details/5156987</guid><author>dengkai_java</author><pubDate>Fri, 08 Jan 2010 11:54:00 +0800</pubDate><description><![CDATA[两个时间相减默认的是天数oracle 两个时间相减默认的是天数*24 为相差的小时数oracle 两个时间相减默认的是天数*24*60 为相差的分钟数oracle 两个时间相减默认的是天数*24*60*60 为相差的秒数测试如下:SQL>select sysdate from dual;       2008-2-20 14:32:35SQL> select (sysd]]></description><category></category></item><item><title><![CDATA[oracle schema]]></title><link>https://blog.youkuaiyun.com/dengkai_java/article/details/4707368</link><guid>https://blog.youkuaiyun.com/dengkai_java/article/details/4707368</guid><author>dengkai_java</author><pubDate>Wed, 21 Oct 2009 10:43:00 +0800</pubDate><description><![CDATA[   我们先来看一下他们的定义：A schema is a collection of database objects (used by a user.). Schema objects are the logical structures that directly refer to the database’s data.A user is a name define]]></description><category></category></item></channel></rss>