摘要：Oracle误删除数据的恢复方法 阅读全文

摘要：instr 类似与js中的indexOf 写法如下： select * from aa where instr(aa.字段,'11')>0 aa表中的字段存在11的所有数据 阅读全文

摘要：to_char(cast(wd.itemcode as nvarchar2(32))) 阅读全文

摘要：select optorname, NVL(现金, 0) as 现金, NVL(银行卡, 0) as 银行卡, NVL(会员卡, 0) as 会员卡, NVL(礼品卡, 0) as 礼品卡, NVL(微信, 0) as 微信, NVL(支付宝, 0) as 支付宝, NVL(会员, 0) as 会员 阅读全文

摘要：create database link DBLINK_klyconnect to user_name identified By pwdusing '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168. 阅读全文