2016年07月_赱向远方

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

原创 Error:java: javacTask: source release 8 requires target release 1.8

change SDK 1.7 to 1.8 code compile errorError:java: javacTask: source release 8 requires target release 1.8Solution：1.File > Settings > Build, Execution, Deployment > Java Compiler2.Change Target

2016-07-27 16:24:44 2306

原创 ORA-02049: timeout: distributed transaction waiting for lock

select 'alter system kill session ''' || sid || ',' || serial# || ''';' from v$session where username = 'XXX';

2016-07-13 10:05:05 3485

原创 /bin/bash^M:

1.:set ff 如果是doc 设置成unix:set fileformat=unix:wq2.如果fileformat是unix还报错sed -i 's/\r//' filenamehttp://stackoverflow.com/questions/2920416/configure-bin-shm-bad-interpreter

2016-07-06 10:31:41 892

原创 ORA-00054: resource busy and acquire with NOWAIT specified

1.select object_name, s.sid, s.serial#, p.spid from v$locked_object l, dba_objects o, v$session s, v$process pwhere l.object_id = o.object_id and l.session_id = s.sid and s.paddr = p.addr;2.alter s

2016-07-05 19:56:42 355

原创 Oracle Create Sequence

CREATE SEQUENCE customers_seq START WITH 1000 INCREMENT BY 1 NOCACHE NOCYCLE;CREATE OR REPLACE TRIGGER JOB_INSTANCE_BRIBEFORE INSERT ON JOB_INSTANCEFOR EACH ROW BEGIN SELECT JOB_INSTA

2016-07-05 16:20:36 1004

原创 Oracle data types and Microsoft SQL Server data types

https://msdn.microsoft.com/en-us/library/ms151817(v=sql.105).aspx

2016-07-05 16:12:19 387

原创 SQL Server delete all tables

/* Drop all non-system stored procs */DECLARE @name VARCHAR(128)DECLARE @SQL VARCHAR(254)SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])WHILE

2016-07-04 14:27:01 1176

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人