char和varchar2对比

来源：互联网发布：域名培训开场白编辑：程序博客网时间：2024/06/05 11:09
-- Create tablecreate table TLCB_HARDWARE_INFO(  sdate                  DATE,  ip                     CHAR(20),  operating_system       VARCHAR2(30),  operatingsystemrelease CHAR(10),  hostname               VARCHAR2(40),  memory_total           CHAR(10),  swap_total             CHAR(10),  manufacturer           VARCHAR2(30))-- Create tablecreate table TLCB_MON_DEVICE(  devicename   VARCHAR2(200),  devicetype   VARCHAR2(200),  ipaddr       VARCHAR2(200),  encodetype   VARCHAR2(200),  descp        VARCHAR2(200),  sysnameshort VARCHAR2(200),  dept         VARCHAR2(200),  hasdeployed  VARCHAR2(200) default 0,  dpmode       VARCHAR2(30))select b.descp,a.* from  tlcb_hardware_info a,tlcb_mon_device bwhere trim(a.ip)=b.ipaddrSQL> select ipaddr,dump(ipaddr) from tlcb_mon_device b where b.ipaddr='10.16.83.2'  2  ; IPADDR                                                                           DUMP(IPADDR)-------------------------------------------------------------------------------- --------------------------------------------------------------------------------10.16.83.2                                                                       Typ=1 Len=10: 49,48,46,49,54,46,56,51,46,50 SQL> select ip,dump(ip) from tlcb_hardware_info b where b.ip='10.16.83.2'; IP                   DUMP(IP)-------------------- --------------------------------------------------------------------------------10.16.83.2           Typ=96 Len=20: 49,48,46,49,54,46,56,51,46,50,32,32,32,32,32,32,32,32,32,32chr(32) 空格符SQL> select ip,dump(ip) from tlcb_cron a where a.ip='10.2.231.1'; IP                   DUMP(IP)-------------------- --------------------------------------------------------------------------------10.2.231.1           Typ=96 Len=20: 49,48,46,50,46,50,51,49,46,49,32,32,32,32,32,32,32,32,32,32  SQL> select  ipaddr,dump(ipaddr) from tlcb_mon_device a where a.ipaddr='10.2.231.1'; IPADDR                                                                           DUMP(IPADDR)-------------------------------------------------------------------------------- --------------------------------------------------------------------------------10.2.231.1                                                                       Typ=1 Len=10: 49,48,46,50,46,50,51,49,46,49
阅读全文
0 0