This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR REPLACE PACKAGE MAILHELPER AS | |
/** | |
* SMTP接続先サーバ | |
*/ | |
VC_MAILHOST VARCHAR2(64) := '127.0.0.1'; | |
/** | |
* SMTP接続先ポート | |
*/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
declare | |
-- UTF8のOracle表現 | |
UTF8 constant nvarchar2(250) := 'AL32UTF8'; | |
-- 改行コード | |
CRLF CONSTANT VARCHAR2(2) := chr(13) || chr(10); | |
-- タブコード | |
TAB CONSTANT VARCHAR2(1) := chr(9); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[[WindowsでのOracle11gR2データベースの構築手順]] | |
-- 現時点では、スクリプトの実行あたりが不完全なので注意 -- | |
参考資料: | |
http://docs.oracle.com/cd/E16338_01/server.112/b56301/toc.htm | |
[1. 環境変数の設定] | |
管理者権限でコマンドプロンプトを空き、以下の環境変数を設定する。 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.Linq; | |
using System.Text; | |
using System.IO; | |
using System.Xml; | |
using System.Xml.Linq; | |
namespace TableColumnDefLib | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// http://msdn.microsoft.com/en-us/library/bb398976.aspx | |
// http://msdn.microsoft.com/en-us/library/bb397499.aspx | |
// http://msdn.microsoft.com/ja-jp/magazine/cc163413.aspx | |
var pageReqMgr = Sys.WebForms.PageRequestManager.getInstance(); | |
// 非同期通信完了後の処理 | |
pageReqMgr.add_pageLoaded(function (sender, args) { | |
var updatedPanels = args.get_panelsUpdated(); | |
if (updatedPanels.length > 0) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// IE6~9で、コンボボックスが二回目のドロップダウンで画面左上に張り付くバグ対応版 | |
// http://www.sencha.com/forum/showthread.php?154412-Combo-Box-options-appears-in-Top-Left-Corner-in-IE-9 | |
Ext.define('Ext.ux.form.field.ComboBox2', { | |
extend: 'Ext.form.field.ComboBox', | |
alias: 'widget.combobox2', | |
requires: ['Ext.form.field.ComboBox'], | |
alternateClassName: ['Ext.form.ComboBox2', 'Ext.form.ComboBox2'], | |
/** | |
* Override of alignment issue where dropdown appears in the top-left corner of the page. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// データ定義 | |
var testdata = [ | |
{ | |
name: 'name1', | |
value: 123, | |
dates: [ | |
{ | |
date: '1a', | |
note: '1aa' | |
}, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR REPLACE package csv_buffer as | |
/** | |
* CSVハンドル | |
*/ | |
type csv_handle is record ( | |
/** | |
* 出力されるCSVのバイナリバッファ. | |
* UTF8エンコードされたCSVの内容が、ここに書き込まれています. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create TYPE ATTACHED_FILE IS object( | |
FILE_NAME NVARCHAR2(256), | |
content blob | |
); | |
/ | |
CREATE OR REPLACE package ODP_BLOB_TEST | |
is | |
type ATTACHED_FILES is table of ATTACHED_FILE index by BINARY_INTEGER; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Configuration; | |
using System.Data; | |
using System.Collections.Generic; | |
using System.Linq; | |
using System.Text; | |
using Oracle.DataAccess.Client; | |
using Oracle.DataAccess.Types; | |
namespace odptest |