笨笨鸟吃柠檬的专栏

C#连接字符集为Ascii的Oracle

先来创建一个存储过程：create or replace procedure up_m_Job isbegin FOR L_RECORD IN ( select id,real_name,is_login,create_on,(sysdate-create_on) *24*60 as miu from ( select ROW_NUMBER() OVER (PARTITION ...

select judge_code, JUDGE_TEXT, sum(man) as ManSum, sum(woman) as WomanSum, count(JUDGE_TEXT) as CountSum from (select t2.param_name, t2.JUDGE_TEXT,

select a.plan_id, '补充说明：' || a.contents as caozuo, ' ' as remarks, a.create_on, a.create_by from PROMOTION_PLAN_SUPPLEMENT a where a.plan_id = '28bae9cc089a446db7264a9ba

--新增主键(没有主键字段，则新增一个主键字段，然后赋值，然后再添加主键)alter table REPORT_ABNORAML add ID number(11) null;--删除序列--drop SEQUENCE SEQ_REPORT_ABNORAML--增加序列CREATE SEQUENCE SEQ_REPORT_ABNORAMLINCREMENT BY 1 -- 每次加几个

问题描述：A机，B机，C机在同一局域网内，A机作为数据库服务，起了监听，且A机通过127.0.0.1或者localhost可以访问，但是B机，C机访问时报ORA-12541:无监听程序的错。解决步骤：1.     修改A机的app\****\product\11.2.0\dbhome_1\NETWORK\ADMIN的tnsnames.ora文件修改方法，添加一条局域网ip的