Skip to content

Instantly share code, notes, and snippets.

@hashmaparraylist
hashmaparraylist / gist:3206922
Created July 30, 2012 13:32
0 reuslt's be selected
select ID
from PEOPLE
where PEOPLE.SEX = 'FEMALE'
and PEOPLE.love = me
@hashmaparraylist
hashmaparraylist / FormateTime.cs
Created April 18, 2013 17:55
输出微秒的格式
DateTimes.Now.ToString("yyyy/MM/dd hh:mm:ss.fff");
@hashmaparraylist
hashmaparraylist / gist:7442379
Created November 13, 2013 02:05
PL/SQL 返回一个数据集
CREATE OR REPLACE PROCEDURE sp_Test
(
Param1 IN OUT DATE,
RetCursor OUT SYS_REFCURSOR
)
IS
BEGIN
OPEN Export_Fx_Mid FOR
SELECT
@hashmaparraylist
hashmaparraylist / update_default_format
Last active December 30, 2015 05:19
Oracle日期型的默认格式修改
update props$ set value$ = 'YYYY-MM-DD' where name='NLS_DATE_FORMAT'
@hashmaparraylist
hashmaparraylist / gen_deploy
Created January 12, 2014 15:16
Octopress 部署博文
rake generate
rake deploy
nohup ssserver > log &
@hashmaparraylist
hashmaparraylist / getiinfo.sql
Created July 3, 2014 06:35
SQLServer 获取数据库表,字段的信息
SELECT
b.name as "Table",
a.name as "COLUMN",
c.name as "Datatype",
a.max_length as "Size",
a.precision,
a.scale ,
case when a.is_nullable =0 then 'NOT Null' else 'NUll' end as "NULL",
case when a.is_identity =0 then '×' else '○' end as "IDENTITY",
case when a.default_object_id = 0 then '×' else d.definition end as 'DEFAULT',
sudo butterfly.server.py --host="0.0.0.0" --unsecure &
@hashmaparraylist
hashmaparraylist / format_curency.js
Created August 25, 2014 07:59
逗号分隔数字
// 输出结果: 12,345
String(12345).replace(/(\d)(?=(\d\d\d)+(?!\d))/g, '$1,');