<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[IT_wind007的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/IT_wind007</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; IT_wind007]]></copyright><item><title><![CDATA[Oracle PLSQL字符串转成数组 BULK COLLECT INTO用法 和 regexp_substr方法]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/116199806</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/116199806</guid><author>IT_wind007</author><pubDate>Tue, 27 Apr 2021 14:12:51 +0800</pubDate><description><![CDATA[-- 核心思想：regexp_substr('str1,abc,efg,str4', '[^,]+', 1, rownum)

--****************************************************************
-- regexp_substr(string, pattern, position, occurrence, modifier)
-- string    : 要处理的字符串
-- pattern   ：正则表达式，[^,]+ ： 至少有一个 ',]]></description><category></category></item><item><title><![CDATA[ORA-12560: TNS:protocol adapter error 或 OraOLEDB.Oracle provider is not registered on local machine]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/115731597</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/115731597</guid><author>IT_wind007</author><pubDate>Thu, 15 Apr 2021 17:21:51 +0800</pubDate><description><![CDATA[Oracle 连接报错：1.ORA-12560: TNS:protocol adapter error.  2.The 'OraOLEDB.Oracle' provider is not registered on the local machine.]]></description><category></category></item><item><title><![CDATA[VB.NET IIF函数, 慎用，有坑！C# 三目运算符 a？b:c]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/112565968</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/112565968</guid><author>IT_wind007</author><pubDate>Wed, 13 Jan 2021 15:40:29 +0800</pubDate><description><![CDATA[VB.NET IIF函数
 IIF函数 是不短路的, 就是说它是 `将后面的两个表达式的值都计算出来 ,才返回值` ； 慎用
C# 三目运算符 a？b:c]]></description><category></category></item><item><title><![CDATA[使用 Visual Basic .NET Framework 4.0 进行多线程编程]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/112470658</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/112470658</guid><author>IT_wind007</author><pubDate>Mon, 11 Jan 2021 15:30:48 +0800</pubDate><description><![CDATA[使用 Visual Basic .NET Framework 4.0 进行多线程编程
多线程连接不同的DB，执行查询
System.Threading.Tasks TASK]]></description><category></category></item><item><title><![CDATA[Visual Basic .net 怎么调用Oracle Procedure存储过程]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/112235188</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/112235188</guid><author>IT_wind007</author><pubDate>Tue, 05 Jan 2021 15:01:37 +0800</pubDate><description><![CDATA[VB.net 程序调用oracle里面的procedure存储过程的两种方法]]></description><category></category></item><item><title><![CDATA[Oracle PL/SQL DB Function 数据库函数]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/111933063</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/111933063</guid><author>IT_wind007</author><pubDate>Wed, 30 Dec 2020 18:11:28 +0800</pubDate><description><![CDATA[1. Oracle PL/SQL DB Function 数据库函数的基础用法
2.Test  DB Function 测试执行函数的语法
3.可以执行 DML 语句的  DB Function]]></description><category></category></item><item><title><![CDATA[显示本机IP及电脑名称等信息的bat脚本]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/111830907</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/111830907</guid><author>IT_wind007</author><pubDate>Wed, 30 Dec 2020 17:43:39 +0800</pubDate><description><![CDATA[@echo off
echo.本机电脑IP
ipconfig|find "IPv4"
echo.
echo.本机计算机名称
hostname
echo.
echo 网页主页
echo.xxxxxx.com
echo.
echo 输入法切换
echo.开始菜单键(Win)+空格键
pause&gt;nul
exit


]]></description><category></category></item><item><title><![CDATA[当内网内没有条件建立dns服务器，又不想用IP访问网站，应配置什么文件？]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/110070859</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/110070859</guid><author>IT_wind007</author><pubDate>Tue, 24 Nov 2020 14:08:23 +0800</pubDate><description><![CDATA[内网内没有条件建立dns服务器，又不想用IP访问网站，应配置Hosts文件。Linux 系统，dns解析]]></description><category></category></item><item><title><![CDATA[Specified cast is not valid Exception；数据类型不一致引起[指定的转化无效]异常]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/109110788</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/109110788</guid><author>IT_wind007</author><pubDate>Fri, 16 Oct 2020 10:59:38 +0800</pubDate><description><![CDATA[`Specified cast is not valid` Exception, 异常:指定的转换无效. Oracle.ManagedDataAccess. Model的属性数据类型，与查询DB的数据类型不一致.]]></description><category></category></item><item><title><![CDATA[Oracle DB版本与“ORA-01417 表可以外部连接到至多一个其他的表”报错]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/108947780</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/108947780</guid><author>IT_wind007</author><pubDate>Wed, 07 Oct 2020 10:18:25 +0800</pubDate><description><![CDATA[查看Oracle DB版本，11g版本左连接SQL报错:“ORA-01417 表可以外部连接到至多一个其他的表”]]></description><category></category></item><item><title><![CDATA[C# 定义变量中类型后带一个问号 `?` --可空引用类型(nullable reference types)]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/108380231</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/108380231</guid><author>IT_wind007</author><pubDate>Thu, 03 Sep 2020 14:46:41 +0800</pubDate><description><![CDATA[C# 定义变量中类型后带一个问号 ? :可为空引用类型/可空类型(nullable reference types). 
dotNet core API: Unable to cast object of type 'System.DBNull' to type 'System.DateTime'.
 空合并运算符：a??b  //表示a不为null时则返回a, 当a为null时则返回b]]></description><category></category></item><item><title><![CDATA[MariaDB安装与使用_HeidiSQL工具]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/107306258</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/107306258</guid><author>IT_wind007</author><pubDate>Sun, 12 Jul 2020 22:17:09 +0800</pubDate><description><![CDATA[MariaDB的安装与入门使用
文章目录MariaDB的安装与入门使用前言一. MariaDB简介二. 下载安装MariaDB三. 验证使用MariaDB命令行:可视化管理工具HeidiSQL:
前言
之前主要使用的DB是Oracle，Mysql等，还没有使用过MariaDB，因此简单记录一下。
通过本文，你将了解到：MariaDB是什么，与Mysql有什么关系，如何下载并安装MariaDB，接着通过命令行指令或HeidiSQL可视化DB管理工具来入门使用MariaDB。
一. MariaDB简介

Mar]]></description><category></category></item><item><title><![CDATA[The provider is not compatible with the version of Oracle client.提供程序与oracle客户端的版本不兼容]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/106634262</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/106634262</guid><author>IT_wind007</author><pubDate>Tue, 09 Jun 2020 14:08:37 +0800</pubDate><description><![CDATA[OracleException (0x80004005): The provider is not compatible with the version of Oracle client (提供程序与oracle客户端的版本不兼容)
[TypeInitializationException: The type initializer for ‘Oracle.DataAccess.Client.OracleConnection’ threw an exception.] (“Oracle.DataAcces]]></description><category></category></item><item><title><![CDATA[The type initializer for Oracle.DataAccess.Client.OracleCommand threw an exception的解决方法]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/106622628</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/106622628</guid><author>IT_wind007</author><pubDate>Mon, 08 Jun 2020 16:38:11 +0800</pubDate><description><![CDATA[The type initializer for 'Oracle.DataAccess.Client.OracleCommand' threw an exception的解决方法升级Oracle DB 到19c 标准版后，(ODAC)程序报错
升级Oracle DB 到19c 标准版后，(ODAC)程序报错

Situation/问题：Oracle DB 升级后，程序部署在安装oracle client 19c 的服务器上，运行时遇到以下报错：
The type initializer for ‘Oracl]]></description><category></category></item><item><title><![CDATA[VS2010调试The following module was built either with optimizations enabled or without debug informatio]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/102383304</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/102383304</guid><author>IT_wind007</author><pubDate>Tue, 08 Oct 2019 14:50:33 +0800</pubDate><description><![CDATA[Visual Studio debug时弹窗提示：The following module was built either with optimizations enabled or without debug information:的解决思路以及方法。]]></description><category></category></item><item><title><![CDATA[(Regular Expression)正则表达式简介和常用的正则表达式模式]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/101069099</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/101069099</guid><author>IT_wind007</author><pubDate>Mon, 23 Sep 2019 08:53:12 +0800</pubDate><description><![CDATA[正则表达式(Regular Expression)概念,以及简单用法:1. 正则表达式：正确规则的表达式。 2. 作用：只用于操作字符串。3. 问题：程序中处理字符串的方法有很多，为什么还需要用正则表达式呢？
   （1） 检验电话号码: patt = /^1[358]\d{9}$/;
   （2）强密码(必须包含大小写字母和数字的组合，不能使用特殊字符，长度在8-10之间)：^(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).{8,10}$ ；
  （3） Email地址； 域名；IP地址..]]></description><category></category></item><item><title><![CDATA[Git新手学习：git commit后出现：please enter the commit message for your changes，如何处理]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/97243384</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/97243384</guid><author>IT_wind007</author><pubDate>Thu, 25 Jul 2019 11:16:34 +0800</pubDate><description><![CDATA[1.每次准备提交前，先用git status看下，是不是都已暂存起来了，然后再运行提交命令git commit -m "message"，但是注意：-m 参数表示可以直接输入后面的message，如果不加 -m 参数，那么是不能直接输入message的，而是会调用一个编辑器一般是vim来让你输入这个message。


$ git status

On branch master
Chang...]]></description><category></category></item><item><title><![CDATA[Pycharm安装Requests或者升级pip时，出现AttributeError: module 'pip' has no attribute 'main'解决的方法]]></title><link>https://blog.youkuaiyun.com/IT_wind007/article/details/96981815</link><guid>https://blog.youkuaiyun.com/IT_wind007/article/details/96981815</guid><author>IT_wind007</author><pubDate>Wed, 24 Jul 2019 08:56:13 +0800</pubDate><description><![CDATA[1.问题：更新pip时（或之后），Pycharm安装其他package时出现报错：AttributeError: module 'pip' has no attribute 'main'。

如图所示：



2.解决方法：（在不降级的情况下）要修改这个文件：

根据错误提示（上图红框），找到pycharm安装目录下的packaging_tool.py：

修改成如下内容：（注意：#注释掉的是原文...]]></description><category></category></item></channel></rss>