dingjing

using System;
using System.Linq;
using Microsoft.AspNet.SignalR;

namespace SignalRDemo.UI {

	public class MyHub1 : Hub {
	
	}
}

dingjing

-- Update OSURF_AWARD_PF_DIM --
MERGE INTO OSURF_AWARD_PF_DIM D USING (
SELECT DISTINCT
  PRCS_FLAG
FROM OSURF_AWARD_FCT_TEMP
) M ON (D.PRCS_FLAG = M.PRCS_FLAG)
WHEN NOT MATCHED THEN INSERT (
  D.AWARD_PF_KEY,
  D.PRCS_FLAG,
  D.IW_INSERT_DT_TM

dingjing

<script language="JavaScript" type="text/javascript" src="../jquery.tablescroll.js"></script>
<script language="JavaScript" type="text/javascript">
Sys.Application.add_load(function(){
	var d = $("#tableContainer");
	var s = d.children("table");
	var t = d.closest("td");
	s.detach().appendTo(t);
	d.remove();
	s.tableScroll({height:200});
});

dingjing

.tablescroll {
  font: 12px normal Tahoma, Geneva, "Helvetica Neue", Helvetica, Arial, sans-serif;
}

.tablescroll td, 
.tablescroll_wrapper,
.tablescroll_head,
.tablescroll_foot { 
  border:1px solid #ccc;
}

dingjing

with col_info as (
select 
  c.owner,
  c.table_name,
  c.column_name,
  c.column_id,
  pc.column_name as PK_COL 
from
  all_tab_cols c join all_constraints p on
    c.owner = p.owner and

dingjing

with col_info as (
select 
  c.owner,
  c.table_name,
  c.column_name,
  c.column_id,
  pc.column_name as PK_COL 
from
  all_tab_cols c join all_constraints p on
    c.owner = p.owner and

dingjing

with dates as (
  select to_date('31-dec-2000 00:00:05') from_date, to_date('31-dec-2000 00:00:15') to_date from dual
  union all
  select to_date('31-dec-2000 23:59:55') from_date, to_date('01-jan-2001 00:00:05') to_date from dual
) select
  round((trunc(to_date, 'MI') - trunc(from_date, 'MI')) * 24 * 60) as min_cross,
  round((trunc(to_date, 'HH') - trunc(from_date, 'HH')) * 24) as hr_cross,
  trunc(to_date, 'DD') - trunc(from_date, 'DD') as day_cross
from
  dates;

dingjing

select 
  datediff(s, from_date, to_date) sec_diff,
  datediff(mi, from_date, to_date) min_diff,
  datediff(hh, from_date, to_date) hr_diff,
  datediff(d, from_date, to_date) day_diff,
  datediff(m, from_date, to_date) mon_diff,
  datediff(yy, from_date, to_date) yr_diff
from (values
  (cast('2000-12-31 00:00:05' as datetime), cast('2000-12-31 00:00:15' as datetime)),
  (cast('2000-12-31 23:59:55' as datetime), cast('2001-01-01 00:00:05' as datetime))

dingjing

select 'record {final_delim=end, record_delim_string=''\n'', delim=''|'', quote=none} (' as col_scm from dual
union all
select * from (
SELECT
  COLUMN_NAME || ':' 
  || CASE WHEN NULLABLE = 'Y' THEN 'nullable ' ELSE '' END 
  || CASE DATA_TYPE  
    WHEN 'NUMBER' THEN 'decimal[' || DATA_PRECISION || ',' || DATA_SCALE || ']'
    WHEN 'TIMESTAMP' THEN 'timestamp'
    WHEN 'DATE' THEN 'date'

dingjing

var ampMembers = MemberTable.GetRecords("AMP = 1");
int random = new Random(DateTime.Now.Ticks).Next(ampMembers.Length);
this.DataSource = ampMembers[random];