weigang.gao
- 浏览: 470206 次
- 性别:
- 来自: 上海
-
文章分类
- 全部博客 (575)
- eclipse (22)
- axis1.4 (3)
- oracle (42)
- java (32)
- 数据结构 (0)
- struts1.x (16)
- struts2.3.8 (14)
- hibernate2.x (3)
- hibernate3.5 (15)
- WinRAR4.20 (2)
- window7 (1)
- problem (1)
- 网址 (17)
- itext (5)
- JavaScript高级程序设计 (22)
- dom4j (1)
- jsp (5)
- jstl (3)
- PL/SQL developer工具 (1)
- derby (1)
- log4j (6)
- HotSpot VM (2)
- poi-2.0-RC2 (2)
- Ubuntu (4)
- weblogic (1)
- Paros安全测试 (2)
- DWR (2)
- jspsmart (2)
- jquery (8)
- css (1)
- jquery ui (2)
- Maven (12)
- Bootstrap (3)
- Ant1.7 (25)
- 保险 (8)
- XFire (3)
- CXF (4)
- Axis2 (5)
- 随笔 (4)
- spring mvc (2)
- dorado (1)
- UML (2)
- spring3.2.2 (9)
- 设计模式 (0)
- JXL (4)
- breakpoints (4)
- Chosen (1)
- BusinessObjects Enterprise XI Release 2 (9)
- FusionCharts (5)
- kettle (2)
- SQL Server 2008 (1)
- struts2.3.8随笔 (20)
- hibernate3.3.2随笔 (6)
- spring2.5.6随笔 (3)
- SVN (4)
- svnkit (1)
- FCKeditor (1)
- ajax (0)
- 日历控件 (1)
- socket编程 (2)
- java并发编程 (10)
- Excel (3)
- Crystal Reports XI Release 2 (1)
- jasperreport(报表工具) (1)
- 微信支付 (1)
- 支付宝支付 (1)
- GISS (1)
- PDF (2)
- hadoop (10)
- json (2)
- 文件上传下载 (1)
- DCSWeb (1)
- acegi security (16)
- oracle编程艺术 (1)
- RAID (1)
- CentOS (19)
- xmanager (1)
- HBase (1)
- Oracle性能优化技术内幕 (0)
- ExtJs (1)
- Oracle SQL高级编程 (0)
- extjs4 (4)
- 微信公众平台 (0)
- mysql (5)
- axure (5)
- mybatis (1)
- MagicDraw UML (0)
- activeMQ (0)
- JMS (1)
- slf4j (1)
- DbUnit (1)
- redis (2)
- SecureCRT (1)
- winSCP (1)
- vmware workstation (1)
- 面试 (5)
- CLodop(Web打印控件) (3)
- IBM MQ (1)
- Spring mvc风格restful接口开发 (1)
- Operating System (2)
- 测试 (0)
- java虚拟机 (17)
- 编译openJDK (1)
- java并发框架-Disruptor3.2 (4)
- Java Magic (3)
- 架构 (1)
- nginx (4)
- 微信开发 (0)
- 大型分布式网站架构设计与实现 (3)
- 阿里RocketMQ (3)
- DUBBO (1)
- zookeeper (3)
- RabbitMQ (0)
- Memcached (0)
- Ehcahe (0)
- AngularJs (0)
- SpringBoot (6)
- 摄影 (1)
- 中通 (9)
- TbSchedule (1)
- 养生 (1)
- Git (1)
- druid (1)
- kafka (2)
- Elasticsearch (2)
- kibana (2)
- 网关 (0)
- HttpClient (0)
- Guava (0)
- 读书 (0)
- 实时应用监控平台CAT (1)
- Python3 (1)
- java8 (1)
- 压测工具之jmeter (0)
- JProfiler (0)
- SSO (0)
- UNIX网络编程 (3)
- DDD (0)
- 下载 (0)
- 国泰 (2)
最新评论
-
wangyudong：
非常详细的代码实例，试着写出了自己的API用Wisdom RE ...
Spring MVC风格的restful接口开发
在很多软件系统中，并没有对非法输入进行处理；将半角数值输入为全角数值的情况很常见(本来应该只能输入半角数值，但是你输入全角字符了)。在存储的时候，一个半角数字占1个byte，但是一个全角数字需要占3个byte
因为全角的原因，原本定义的字段长度很容易出现长度不够的情况
可以使用oralce的内置函数to_single_byte来转换一下，使用这个函数会将全角字符转换为半角的字符，对于半角的字符不做处理
select to_single_byte('ｇａｏｗｅｉｇａｎｇ222') from dual
--结果：gaoweigang222 而不是ｇａｏｗｅｉｇａｎｇ222
因为全角的原因，原本定义的字段长度很容易出现长度不够的情况
可以使用oralce的内置函数to_single_byte来转换一下，使用这个函数会将全角字符转换为半角的字符，对于半角的字符不做处理
select to_single_byte('ｇａｏｗｅｉｇａｎｇ222') from dual
--结果：gaoweigang222 而不是ｇａｏｗｅｉｇａｎｇ222
分享到：
发表评论
-
oracle分页查询（面试）
2017-02-28 13:51 815ROWNUM rowid与rownum虽都被称为伪列，但它 ... -
Oracle中的rownum不能使用大于>的问题
2017-02-28 10:54 856参考：http://www.cnblogs.com/jav ... -
oracle去重(面试)
2017-02-28 10:03 466现有Oracle中数据如下： 第一种方法： 使用 ... -
listener.ora/sqlnet.ora/tnsnames.ora配置文件详解
2017-02-21 17:36 672在Win7 64位系统里面安装oracle 32位可能遇到 ... -
本机不安装Oracle客户端，使用PL/SQL Developer连接远程数据库
2016-03-15 08:33 528一：本机不安装Oracle客户端，使用PL/SQL Dev ... -
PLS-00313: 'XXXXX' not declared in this scope
2016-01-28 16:50 2202Package中私有的Procedure/Function( ... -
高效率优化Oracle SQL
2016-01-24 21:36 1092好多同学对sql的优化好像是知道的甚少，最近总结了几条仅供 ... -
Oracle日期处理
2015-12-22 11:21 499--1.Oracle查询2个月份之间的所有月份 selec ... -
ORACLE 日期函数 MONTHS_BETWEEN
2015-11-24 11:16 1110格式：MONTHS_BETWEEN(DATE1,DATE2) ... -
解决ORA-04068 异常existing state of packages has been discarded
2015-10-26 15:45 1176http://blog.csdn.net/ningxuezhu ... -
oracle中rank() over与row_number()的区别
2015-09-07 15:29 674PARTITION by emp_no ORDER BY s ... -
DCSweb
2015-09-01 16:04 407--获取当月最后一天 select to_date('2 ... -
同一个语句块中对同一张表的DML操作 并不会锁表
2015-08-26 10:30 310同一个语句块中对同一张表的DML操作 并不会锁表 -
row_number() over获取每类中最新的一条记录
2015-08-20 18:14 2199第一种写法： select t.tj_agi ... -
oracle定时任务
2015-07-22 21:04 471oracle定时任务 http://my.osch ... -
oracle获取当前时间点的前3个月的时间点
2015-06-24 16:06 3144select add_months(sysdate,-3) f ... -
数据库 分布式
2015-04-25 20:26 381数据库 分布式 -
format code appears twice
2015-04-18 16:34 740今天在执行脚本的时候，oracle报如下错误 Orac ... -
Oracle tablespace(表空间)
2015-04-13 23:33 524Oracle 表空间 -
Oracle 同义词
2015-04-13 23:32 505同义词
相关推荐
信息安全_数据安全_Single byte write to RCE：exploit 安全实践 信息安全 安全防御 云安全 安全体系
Single Statement Blocks List Comprehension Using List Comprehensions Receiving Tuples and Lists in Functions Lambda Forms Using Lambda Forms The exec and eval statements The assert statement ...
第一部分 Oracle SQL*PLUS基础 23 第一章 Oracle数据库基础 23 §1.1 理解关系数据库系统（RDBMS） 23 §1.1.1 关系模型 23 §1.1.2 Codd十二法则 24 §1.2 关系数据库系统（RDBMS）的组成 24 §1.2.1 RDBMS 内核 24...
数据库表 test 字段 id name age 全角数字:１２３４ 半角数字:1234 length和lengthb的区别: length(1234) 4 ... update test t1 set t1.age = (select to_single_byte(t2.age) from test t2
VB调用C的dll库实例，4字节转为1个实数,用于通讯数值转换
4BYTE字节转换成float型数据代码
void I2C_SendByte(u8 SendByte) ; unsigned char I2C_RadeByte(void); void READ_MPU6050(void); u8 Single_Write(unsigned char SlaveAddress,unsigned char REG_Address,unsigned char REG_data); void GPIO_...
msp430x261x_dma_11_IAR.c - (Built with IAR) DMA0/1, ADC12 A10 rpt single transfer Xfer to MPY/RAM, TBCCR1, DCO DMA0/1, Block Mode UART1 9600 Auto RX/TX String, ACLK Flash In-System Programming, Copy ...
ARM processors and coprocessors up to and including v8. Contents: 1. ARM assembly compatibility 2. UAL and pre-UAL syntaxes 3. IT block handling 4. Alternate encodings 5. Output formats ...
# YOU CAN CREATE YOUR OWN BYTE ARRAY OF PACKET_SIZE packet = bytearray(packet_size) for i in range(packet_size): packet[i] = (i %6) # ... AND SET IT TO STUPID ARTNET a.set(packet) # YOU CAN CHANGE ...
全志R16平台编译linux系统V1.0.txt 2017/4/11 13:36 （编译请使用编译android的lichee的选项编译生成的.config文件，不然直接编译会报错！！...rootroot@cm-System-Product-Name:/home/...Preparing to unpack ......
Removed functions to convert from span<byte> to span<T> as they are not compatible with type aliasing rules. Introduced dependency on P0257 [6] for definition of byte type, in order to support ...
What if I want to everything in single line od -An -t x1 -v a.out | tr -d '\n' How to convert continuous space in text file into single one od -An -t x1 -v a.out | tr -d '\n' | tr -s ' ' > a.txt How ...
This is a shared library for Android, iOS, OSX, ...- Ability to decode/encode a byte buffer to/from the lzma alone format. - Ability to cancel the decompression when the 7z archive has multiple entries.
# Read the entire file as a single byte string with open('somefile.bin', 'rb') as f: data = f.read() # Write binary data to a file with open('somefile.bin', 'wb') as f: f.write(b'Hello World') 在...
vb字节转浮点数的例程,可以直接使用. Private Sub Command1_Click() ...Dim BB(0 To 3) As Byte Dim se As Single BB(0) = Text1.Text BB(1) = Text2.Text BB(2) = Text3.Text BB(3) = Text4.Text
3. UIDF2: anti-collision and selection with a single size random ID according to ISO/IEC 14443-3 4. UIDF3: anti-collision and selection with a single size NUID according to ISO/IEC 14443-3 where the ...
A single byte (AMP) written to the HV892 controls the operation of the driver. Setting AMP = 01h to FFh controls output amplitude in 255 monotonic steps. Setting AMP = 00h causes the HV892 to go into ...
• Single Power Supply Operation - 2.7 to 3.6 volt for read, erase, and program operations • Serial Peripheral Interface compatible -- Mode 0 and Mode 3 • 67,108,864 x 1 bit structure or 33,554,432 ...
• Bidirectional/differential data strobe per byte lane • Programmable READ and WRITE latencies (RL/WL) • Programmable and on-the-fly burst lengths (BL = 16, 32) • Directed per-bank refresh for ...