<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[对酒当歌，人生几何？譬如朝露，去日苦多]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/gal1024</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; gal1024]]></copyright><item><title><![CDATA[C# 调用Delphi 方法 指针参数处理]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/89354992</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/89354992</guid><author>gal1024</author><pubDate>Wed, 17 Apr 2019 14:27:19 +0800</pubDate><description><![CDATA[C#项目调用 Delphi 方法，其中

Delphi 声明：

function SendEx(AName,ACommand,AContent:PAnsiChar;var AResult:PAnsiChar):Boolean; stdcall;

测试 参数使用 string，stringBulider，IntPtr，string[] 都无果

========================...]]></description><category></category></item><item><title><![CDATA[ORCL 错误收集]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/43076727</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/43076727</guid><author>gal1024</author><pubDate>Sat, 24 Jan 2015 01:21:25 +0800</pubDate><description><![CDATA[Fatal NI connect error 12170


说明：这个问题是由于Automatic Diagnostic Repository中的 Oracle Net diagnostic在默认的情况下是开启的，当数据库和客户端的连接超过特定时间，就会把这样的信息写入到alert日志中，所以这不是一个致命的问题，如果偶尔出现，可以忽略有点类此ora-3136的错误





]]></description><category></category></item><item><title><![CDATA[oracle中创建临时表方法]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/41022483</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/41022483</guid><author>gal1024</author><pubDate>Tue, 11 Nov 2014 23:18:49 +0800</pubDate><description><![CDATA[1.首先必须有权限：
创建临时表的用户好像必须要有CREATE ANY TABLE 如果你有这个权限的还
按照上面两位说得一定可以。
 

2.建表的语法示例：
-------创建虚拟表
create global temporary table  test (
ssid int,
sname varchar2(20)
) on commit delete rows;
---]]></description><category></category></item><item><title><![CDATA[oracle中 connect by prior 递归算法]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40343167</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40343167</guid><author>gal1024</author><pubDate>Tue, 21 Oct 2014 13:05:40 +0800</pubDate><description><![CDATA[http://blog.163.com/xxciof/blog/static/7978132720095193113752/ 

oracle中 connect by prior 递归算法 

Oracle中start with...connect by prior子句用法 connect by 是结构化查询中用到的，其基本语法是： 
select ... from tablename ]]></description><category></category></item><item><title><![CDATA[Oracle递归查询]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40342729</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40342729</guid><author>gal1024</author><pubDate>Tue, 21 Oct 2014 11:58:06 +0800</pubDate><description><![CDATA[创建表
 建表语句：


CREATE TABLE SC_DISTRICT
(
  ID         NUMBER(10)                  NOT NULL,
  PARENT_ID  NUMBER(10),
  NAME       VARCHAR2(255 BYTE)          NOT NULL
);

ALTER TABLE SC_DISTRICT AD]]></description><category></category></item><item><title><![CDATA[ORCL_PROC]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40324429</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40324429</guid><author>gal1024</author><pubDate>Mon, 20 Oct 2014 23:17:35 +0800</pubDate><description><![CDATA[--错误处理部分。OTHERS表示除了声明外的任意错误。SQLERRM是系统内置变量保存了当前错误的详细信息。 
 
 
EXCEPTION 

   WHEN OTHERS THEN 
      vs_msg := 'ERROR IN xxxxxxxxxxx_p('||is_ym||'):'||SUBSTR(SQLERRM,1,500);
 
   ROLLBACK; 

]]></description><category></category></item><item><title><![CDATA[oracle索引，索引的建立、修改、删除]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40299641</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40299641</guid><author>gal1024</author><pubDate>Mon, 20 Oct 2014 13:41:15 +0800</pubDate><description><![CDATA[索引，索引的建立、修改、删除 
2007-10-05 13:29　来源: 作者： 网友评论 0 条 浏览次数 2986 
索引
索引是关系数据库中用于存放每一条记录的一种对象，主要目的是加快数据的读取速度和完整性检查。建立索引是一项技术性要求高的工作。一般在数据库设计阶段的与数据库结构一道考虑。应用系统的性能直接与索引的合理直接有关。下面给出建立索引的方法和要点。
§3.5.1 建立索引]]></description><category></category></item><item><title><![CDATA[ORCL SYS]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40298035</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40298035</guid><author>gal1024</author><pubDate>Mon, 20 Oct 2014 11:11:23 +0800</pubDate><description><![CDATA[-- 查看表操作sql
select * from v$sqlarea t where t.PARSING_SCHEMA_NAME in ('ZHIFY') order by t.LAST_LOAD_TIME desc;
-------oracle 查看已经执行过的sql 这些是存在共享池中的 --------->
select * from v$sqlarea t order by t.L]]></description><category></category></item><item><title><![CDATA[ORCL 系统相关]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40276207</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40276207</guid><author>gal1024</author><pubDate>Sun, 19 Oct 2014 23:09:37 +0800</pubDate><description><![CDATA[create or replace procedure galpro is Warning: Procedure created with compilation errors

  2  cursor cur is select * from scott.emp where depno=20; 
  3  begin 
  4  for i in cur loop ORA-06550: ]]></description><category></category></item><item><title><![CDATA[ORCL  MSSQL 异同]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40275995</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40275995</guid><author>gal1024</author><pubDate>Sun, 19 Oct 2014 23:07:23 +0800</pubDate><description><![CDATA[ORACLE SQL
字串连接 || +'
流控制（Control-of-Flow）语言 
声明变量 DECLARE DECLARE 
语句块 BEGIN...END 
条件处理 IF…THEN,   ELSIF…THEN,   ELSE   ENDIF; IF…[BEGIN…END]   ELSE   [BEGIN…END]        ELSE IF   CASE expressi]]></description><category></category></item><item><title><![CDATA[ORCL基础总结]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40274521</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40274521</guid><author>gal1024</author><pubDate>Sun, 19 Oct 2014 23:01:56 +0800</pubDate><description><![CDATA[逻辑符号 与 
ORACL SQL 
||  concat ‘+ 

order by asc（默认 低到高） desc高到底 
select * from gal  order by sal asc, id desc 
function 
字符 select UPPer('galgal') from dual; 
where name=upper("gal") 
Lower ]]></description><category></category></item><item><title><![CDATA[ORCL工作中学习汇总]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40272777</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40272777</guid><author>gal1024</author><pubDate>Sun, 19 Oct 2014 22:05:09 +0800</pubDate><description><![CDATA[每天进步一点点，积少成多，]]></description><category></category></item><item><title><![CDATA[orcl clob 数据插入报错处理_test]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40163011</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40163011</guid><author>gal1024</author><pubDate>Fri, 17 Oct 2014 00:02:32 +0800</pubDate><description><![CDATA[begin
DECLARE REALLYBIGTEXTSTRING CLOB := '待插入的海量字符串'; 
BEGIN
INSERT INTO oplog(ssql)VALUES(  REALLYBIGTEXTSTRING  );commit;
end ;
end;]]></description><category></category></item><item><title><![CDATA[如何解决ORA-01033问题（数据文件误删除 ）]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/40110445</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/40110445</guid><author>gal1024</author><pubDate>Wed, 15 Oct 2014 14:26:08 +0800</pubDate><description><![CDATA[(2010-05-08 20:49:35)
转载▼





标签：
oracle
my
日志文件
数据文件
sql
it

 





Oracle错误：ORA-01033


错误编码：ORA-01033: ORACLE initialization or shutdown in progress


故障描述：因为移动了数据库文件（[N]]></description><category></category></item><item><title><![CDATA[SQL 之Group by with Rollup 的效果]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/39532947</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/39532947</guid><author>gal1024</author><pubDate>Wed, 24 Sep 2014 23:33:49 +0800</pubDate><description><![CDATA[转载于:
/* 
建立示例过程，以演示Group by with Rollup 的效果 
*/
-- 建一临时表 
create table #tmpA 
( Dept char(3) , Sect char(3) , line char(3) , Line_Desc varchar(30) , Title_code char(3) , Title_Desc varchar(30) ,]]></description><category></category></item><item><title><![CDATA[SQL Server中Rollup关键字使用技巧]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/39520351</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/39520351</guid><author>gal1024</author><pubDate>Wed, 24 Sep 2014 10:40:39 +0800</pubDate><description><![CDATA[首先创建测试表、添加数据。
create table #t(a int,b int,c int,d int,e int)
insert into #t values(1,2,3,4,5)
insert into #t values(1,2,3,4,6)
insert into #t values(1,2,3,4,7)
insert into #t values(1,2,3,4,8)
i]]></description><category></category></item><item><title><![CDATA[sqlserver 中 将数据 导出为  insert语句 的Proc]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/39479119</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/39479119</guid><author>gal1024</author><pubDate>Mon, 22 Sep 2014 17:18:27 +0800</pubDate><description><![CDATA[最近需要导出一个表的数据并生成insert语句，发现SQL Server的自带工具并没有此功能。BAIDU一下得到如下方法（亲测OK）
用这个存储过程可以实现：
CREATE PROCEDURE dbo.UspOutputData 
@tablename sysname 
AS 
declare @column varchar(1000) 
declare @columndata va]]></description><category></category></item><item><title><![CDATA[TB_Area  ID PID  root 省市县 数据表(二)]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/39380315</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/39380315</guid><author>gal1024</author><pubDate>Thu, 18 Sep 2014 22:45:34 +0800</pubDate><description><![CDATA[转载于 ：http://down.51cto.com/data/76711]]></description><category></category></item><item><title><![CDATA[全国省市数据库（一）]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/39379637</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/39379637</guid><author>gal1024</author><pubDate>Thu, 18 Sep 2014 22:17:35 +0800</pubDate><description><![CDATA[create table promary
(
 proID int primary key,
 proName varchar(50) not null
)


----------------------------------------------------------------------------------------------------------------]]></description><category></category></item><item><title><![CDATA[弹出窗口总结]]></title><link>https://blog.youkuaiyun.com/gal1024/article/details/39338451</link><guid>https://blog.youkuaiyun.com/gal1024/article/details/39338451</guid><author>gal1024</author><pubDate>Wed, 17 Sep 2014 10:01:33 +0800</pubDate><description><![CDATA[1//刷新父窗口的父窗口
 2Dim strScript As String = "Script Language='VBScript'>" & vbCrLf
 3strScript &= "opener.parent.document.location.href=""" & "../Individual/UserJobs.aspx?EntityTableID=" & Request("Ent]]></description><category></category></item></channel></rss>