数据库
leileiazqy
这个作者很懒,什么都没留下…
展开
-
left join理解
create table lily1 (idx number(12), unamex varchar2(100));create table lily2 (idy number(12), unamey varchar2(100));create table lily3 (idz number(12), unamez varchar2(100)); insert into lily...原创 2015-06-16 17:57:24 · 180 阅读 · 0 评论 -
FAILED_LOGIN_ATTEMPTS不起作用
“FAILED_LOGIN_ATTEMPTS”是密码输错最多允许次数,超过后账号锁定。1、查看:select * from dba_profiles s where s.profile='DEFAULT' and resource_name='FAILED_LOGIN_ATTEMPTS'; 2、无限次:alter profile default limit failed_login_at...原创 2017-11-03 16:28:35 · 5077 阅读 · 0 评论 -
JPA主键
以下内容是自己遇到:----------------方式 A ------------------@javax.persistence.id @javax.persistence.SequenceGenerator(name="gen1", sequenceName="SEQTEST1")@javax.persistence.GeneratedValue(generat...原创 2017-12-27 10:56:14 · 159 阅读 · 0 评论 -
JPA怎么写注解使字段类型为date且写入数据带时分秒(oracle数据库)
@javax.persistence.Basic@javax.persistence.Column(name="PUSH_DATE", columnDefinition="DATE")@Temporal(value = TemporalType.TIMESTAMPE)public java.util.Date getPushDate() {return pushDate; } ...2018-01-04 13:33:17 · 4111 阅读 · 1 评论 -
left join 列名重复时的BUG
实验数据库:oracle实验数据:create table lilytestm ( id number(2), cloudname varchar2(20), colundtype varchar2(20));create table lilytests ( id number(2), mid number(2), cloudcolor varchar2(20), colundtype ...原创 2019-08-13 19:44:15 · 2481 阅读 · 0 评论