数据链路的创建,ORA-02019: 未找到远程数据库的连接说明
CREATE PUBLIC DATABASE LINK emrjktozjhis1122
CONNECT TO zjhis IDENTIFIED BY zjhis
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = emr_local)))';
运用:select t.*,t.rowid from GY_BQDM@emrjktozjhis1122 t
彻底删除表
drop table BL_BINGRENJBXX_V4;--删除表
purge recyclebin;--清除回收站
数据库用户有效期设置-永久-默认为180D
新添:command window 执行ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED ;--修改
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';--查询 确认
oracle用户操作
create user emr identified by emr ;
drop user emr [cascade] (后边的单词在删除非空用户时加上)
grant connect,resource to user ; (将当前用户的全部表授权给user)
grant dba to emr (需在管理员权限下运行,赋予emr管理员权限)
grant unlimited tablespace to zhangsan; (授予zhangsan用户使用表空间的权限)
grant select,insert,update,delete on pdjh.pd_jhxx to his3; ()
查询全部用户名
select username from dba_users (用数据库管理员身份查询)声称全局唯一标识符
string jlguid =Guid.NewGuid().ToString();
与数据库交互,遍历符合条件的数据
DBVisitor.ExecuteNonQuery(string.Format("update gy_bingrenxx set jiatingdh='" + lianXiDh +"'");
DataTable dt=null;
string sql =null;
try
{
sql =" select * from gy_Shangchuanxm where ";
dt = DBAccess.GetDataTable(DBAccess.EMR3, sql);
}
catch (Exception ex)
{
AppGlobalObj.Log.Error(ex.Message);
}
foreach (DataRow rowin dtmx.Rows)
{
xiangMuBm =Convert.ToString(row["XIANGMUBM"]);
xiangMuMc =Convert.ToString(row["XIANGMUMC"]);
以特殊字符为标记,截字符串,并存入数组中
string[] wcfCanShu = wcfCanShu1.Split('|');
保存date数据类型的sql语句
string updaterz1 ="update GY_SHANGCHUANJL set shangchuanjg='上传成功',CAOZUOJSSJ=to_date('" +DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") +"','yyyy-MM-dd HH24:mi:ss') where SCJLID='" + SCJLID +"'";
插入数据
INSERT INTO table1(id, name, address) VALUES(1, ygl, 'beijing');
INSERT INTO table2 SELECT id, name, address FROM table1;
多字段排序,并且按照某个字段倒序
select * from table order by shijian desc,xuhao,biaoji asc,yangshi
用log4net.dll写日志
using log4net;
static ILog log = log4net.LogManager.GetLogger("XmlLog");
log.InfoFormat("[{2}][{0}].OUT {1}", "111", "111", "111");
log.InfoFormat("[{2}][{0}].OUT {1}", TradeType, TradeMsgOut, guid);
log.InfoFormat("{0}", msg + "\r\n");
程序暂停一段时间(义乌中心医保APP)
System.Threading.Thread.Sleep(60000);