06 2022 档案
摘要:--相关表 SELECT * FROM v$lock; SELECT * FROM v$sqlarea; SELECT * FROM v$session; SELECT * FROM v$process; SELECT * FROM v$locked_object; SELECT * FROM al
阅读全文
摘要:CREATE OR REPLACE FUNCTION MD5(passwd IN VARCHAR2) RETURN VARCHAR2 IS retval varchar2(32); BEGIN retval := utl_raw.cast_to_raw(DBMS_OBFUSCATION_TOOLKI
阅读全文
摘要:1.查看服务器IP select UTL_INADDR.get_host_address() from dual; 2.当前会话主机IP select sys_context('USERENV', 'IP_ADDRESS') from dual 3.服务器主机名 SELECT host_name f
阅读全文
摘要:1.获取CPU详细信息 cat /proc/cpuinfo 2.查看物理CPU个数 cat /proc/cpuinfo |grep "physical id"|sort |uniq |wc -l 3.查看CPU核数 cat /proc/cpuinfo |grep "cores"|uniq 4.查看C
阅读全文
摘要:下载地址 NuGet Package Manager - Visual Studio Marketplace NuGet包地址 NuGet Gallery | Home
阅读全文
摘要:NLog.Config <?xml version="1.0" encoding="utf-8" ?> <nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSc
阅读全文
摘要:1、安装pyzbar pip install pyzbar 2、代码 import os import cv2 as cv from pyzbar import pyzbar # 目录路径 path = "D:\data_img" data = []; file_list = os.listdir(
阅读全文
摘要:mybatis xml 文件中对于重复出现的sql 片段可以使用标签提取出来,在使用的地方使用标签引用即可具体用法如下: <sql id="Base_Column_List"> id,name </sql> <select id="select"> select <include refid="Ba
阅读全文
摘要://本月 @Test public void test01() { SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); Calendar c = Calendar.getInstance(); c.add(Calendar.MO
阅读全文
摘要:select trunc(sysdate, 'mm'), last_day(trunc(sysdate)), trunc(add_months(trunc(sysdate), -1), 'mm'), last_day(add_months(trunc(sysdate), -1)), trunc(ad
阅读全文
摘要:using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.
阅读全文
摘要:表结构、测试数据 drop table t1; drop table t2; CREATE TABLE T1 ( name VARCHAR2(10) , code VARCHAR2(10) ); ALTER TABLE t1 ADD PRIMARY KEY(name); insert into t1
阅读全文
摘要:1.常规用法 v_sql varchar2(1000); v_sql := 'update Test set name= ''lw112190'' where id= 1'; execute immediate v_sql; 2.执行sql语句,并赋值给某个变量 v_sql := 'select n
阅读全文