https://blog.youkuaiyun.com/diguoguozh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/diguoguo/article/details/84322498https://blog.youkuaiyun.com/diguoguo/article/details/84322498diguoguoWed, 21 Nov 2018 15:07:46 +0800https://blog.youkuaiyun.com/diguoguo/article/details/84322379https://blog.youkuaiyun.com/diguoguo/article/details/84322379diguoguoWed, 21 Nov 2018 15:06:43 +0800https://blog.youkuaiyun.com/diguoguo/article/details/82587906https://blog.youkuaiyun.com/diguoguo/article/details/82587906diguoguoMon, 10 Sep 2018 12:15:32 +0800https://blog.youkuaiyun.com/diguoguo/article/details/7241728https://blog.youkuaiyun.com/diguoguo/article/details/7241728diguoguoWed, 08 Feb 2012 11:00:10 +0800https://blog.youkuaiyun.com/diguoguo/article/details/6185536https://blog.youkuaiyun.com/diguoguo/article/details/6185536diguoguoTue, 15 Feb 2011 11:12:00 +0800OERR: ORA-12519 TNS:no appropriate service handler found
客户端连接间歇性失败，报错ORA-12519
Cause: the listener could not find any available service handlers that are 
       appropriate for the client connection.
Action:  检查lsnrctl service ，]]>https://blog.youkuaiyun.com/diguoguo/article/details/6166195https://blog.youkuaiyun.com/diguoguo/article/details/6166195diguoguoThu, 27 Jan 2011 11:36:00 +0800在安全系统中创建一项，以拒绝给当前数据库内的安全帐户授予权限并防止安全帐户通过其组或角色成员资格继承权限。语法
语句权限：
DENY { ALL | statement [ ,...n ] }
TO security_account [ ,...n ]
对象权限：
DENY
    { ALL [ PRIVILEGES ] | permission [ ,...n ] }
    {
        [ ( co]]>https://blog.youkuaiyun.com/diguoguo/article/details/6166149https://blog.youkuaiyun.com/diguoguo/article/details/6166149diguoguoThu, 27 Jan 2011 11:22:00 +0800SQL中IN,NOT IN,EXISTS,NOT EXISTS的用法和差别:

IN:确定给定的值是否与子查询或列表中的值相匹配。
IN 关键字使您得以选择与列表中的任意一个值匹配的行。
当要获得居住在 California、Indiana 或 Maryland 州的所有作者的姓名和州的列表时，就需要下列查询：
SELECT ProductID, ProductName FROM Northwind.dbo.Products WHERE Cate]]>https://blog.youkuaiyun.com/diguoguo/article/details/6165880https://blog.youkuaiyun.com/diguoguo/article/details/6165880diguoguoThu, 27 Jan 2011 09:43:00 +0800为了更好合理的试用医保程序进行调试现将需要注意的一些事项列举和加以注意：
第一种设计程序：
第一步：]]>https://blog.youkuaiyun.com/diguoguo/article/details/5909949https://blog.youkuaiyun.com/diguoguo/article/details/5909949diguoguoMon, 27 Sep 2010 16:17:00 +0800Oracle在线重做日志文件详解
1:查看数据库在线重做日志文件的归档方式
ARCHIVE LOG list;
2:查看日志组
SELECT * FROM v$log;
3:查看日志组成员
SELECT * FROM v$logfile;
--备注：经分系统BONCBI数据库日志没做归档就不说了，既然只有3个日志组，而且既然每个日志组只有一个成员，悲剧啊！
4：新增一个日志组：
ALTER DATABASE]]>https://blog.youkuaiyun.com/diguoguo/article/details/5909901https://blog.youkuaiyun.com/diguoguo/article/details/5909901diguoguoMon, 27 Sep 2010 16:00:00 +0800 1. After触发器：这类触发器是在记录已经改变完之后（after），才会被激活执行，
         它主要是用于记录变更后的处理或检查，一旦发现错误，也可以用Rollback Transaction语句来回滚本次的操作。

 2. Instead Of触发器：这类触发器一般是用来取代原本的操作，在记录变更之前发生的，它并不去执行
原来SQL语句里的操作（Insert、Update、Dele]]>https://blog.youkuaiyun.com/diguoguo/article/details/6506945https://blog.youkuaiyun.com/diguoguo/article/details/6506945diguoguoMon, 27 Sep 2010 11:36:00 +0800