摘要: 1、使用拼接符号“||” v_sql := 'SELECT * FROM UserInfo WHERE ISDELETED = 0 AND ACCOUNT =''' || vAccount || ''' AND PASSWORD = ''' || vPassword || ''''; 2、使用ASC 阅读全文
posted @ 2018-01-19 18:11 vofill-work 阅读(15168) 评论(0) 推荐(0)
摘要: JDBC Type Java Type CHAR String VARCHAR String LONGVARCHAR String NUMERIC java.math.BigDecimal DECIMAL java.math.BigDecimal BIT boolean BOOLEAN boolea 阅读全文
posted @ 2018-01-19 14:01 vofill-work 阅读(172) 评论(0) 推荐(0)
摘要: 一、以管理员身份登录 SQL> conn sys/sys as sysdba; (分号是必须的但是我是以system登录的所在这不应该写conn sys/sys as sysdba应该写conn system/orcl as sysdba;)Connected. 二、解锁被锁用户SQL> alter 阅读全文
posted @ 2018-01-19 10:07 vofill-work 阅读(198) 评论(0) 推荐(0)