随笔分类 -  Oracle

摘要:var is_over = new ObjectParameter("ISOVER", typeof(string)); context.ExecuteFunction("AERO_STATUS_JUDGE", new ObjectParameter("AERO_ID", aero_id), is_over); string ret = is_over.Value.ToString();int K = context.ExecuteStoreCommand("delete from SRC_DEF_PLATFORM_AERO 阅读全文
posted @ 2013-05-13 16:42 louiskoo 阅读(558) 评论(0) 推荐(0) 编辑
摘要:<EntityType Name="视图名称"> <Key><PropertyRef Name="主键的列名1" /><PropertyRef Name="主键的列名2" /><PropertyRef Name="主键的列名3" /> </Key> <Property Name="主键的列名1" Type="varchar2"Nullable="false"MaxLength=& 阅读全文
posted @ 2013-04-19 21:14 louiskoo 阅读(517) 评论(0) 推荐(0) 编辑
摘要:ISNULL ( check_expression , replacement_value) 参数 check_expression 将被检查是否为 NULL的表达式。check_expression 可以是任何类型的。 replacement_value 在 check_expression 为 NULL时将返回的表达式。replacement_value 必须与 check_expresssion 具有相同的类型。 返回类型 返回与 check_expression 相同的类型。 注释 如果 check_expression 不为 NULL,那么返回该表达式的值;否则返... 阅读全文
posted @ 2013-04-19 19:23 louiskoo 阅读(211) 评论(0) 推荐(0) 编辑
摘要:update imcc.jxdw_v_seat_traffic set sid = rownum;commit;ALTER TABLE "JXDW_CTI_CALL_LIST" ADD CONSTRAINT PK_JXDW_CTI_CALL_LIST PRIMARY KEY ( "LIST_ID") ENABLE VALIDATE alter table <table> add contraint pk_table primary key (<column> oracle没有ORACLE自增字段这样的功能,但是通过触发器(trig 阅读全文
posted @ 2013-04-18 15:09 louiskoo 阅读(2585) 评论(0) 推荐(0) 编辑
摘要:imp userid=用户名/密码@orcl file=d:\nc60.dmp full=y用户名 :就是你的目标用户 。密码 :就是你的目标用户登录密码。orcl:是实例名称 就是数据库名file:就是你要导入的dmp文件全路径。full=y 是否全部导入 只有当前用户是dba的时候 才能用此选项 。 阅读全文
posted @ 2013-04-18 14:50 louiskoo 阅读(221) 评论(0) 推荐(0) 编辑
摘要:string connStr = @"Data Source=XE;User ID=AI;password=sa"; OracleConnection conn = new OracleConnection(connStr); Ai dt = new Ai(conn); var result = from t in dt.Platform join c in dt.Car on t.PlatID equals c.PlatID ... 阅读全文
posted @ 2013-04-09 04:03 louiskoo 阅读(155) 评论(0) 推荐(0) 编辑
摘要:https://forums.oracle.com/forums/thread.jspa?threadID=2177895&tstart=90As far as i have worked on EF4 using Oracle , Function importing doesn't seems to work here. I faced the same problem few months back and tried many ways to import a function but without any luck. But during searching I f 阅读全文
posted @ 2013-04-09 04:00 louiskoo 阅读(663) 评论(0) 推荐(0) 编辑
摘要:createorreplace package body package_user AS PROCEDURE PERSON_QUERY(RS OUT MY_RESULTSET_CURSOR,C OUTINTEGER) AS BEGIN OPEN RS FORselect * from emp; update A set ename='AAA'; SELECTCOUNT(*) INTO C from emp; END PERSON_QUERY; END; 阅读全文
posted @ 2013-04-09 03:05 louiskoo 阅读(139) 评论(0) 推荐(0) 编辑
摘要:alter table imcc.agentstatuslog add primary key (id)select count(1) from imcc.agentstatuslog where id is nulldelete from imcc.agentstatuslog where id is null 阅读全文
posted @ 2013-04-09 01:42 louiskoo 阅读(194) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示