摘要:
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)
浙公网安备 33010602011771号