DataBase

1.clobデータを初期化

insertinto user_tbl(no, user_id, user_memo)values (1, 'yamada', empty_clob());

2.blobデータを初期化

in ...

SQL構文
SELECT CAST(sysdate AS TIMESTAMP) from dual;

追加
db.test_collection.ensureIndex( { name : 1 } );

削除
db.test_collection.dropIndex( { name : 1 } ); ...

例1
SELECT CASE WHEN a < b THEN b
ELSE a END AS maxVal
FROM TEST_TBL;

例2
SELECT CASE WHEN CAS ...

1.Dockerfileを導入
$ cd/usr/local/src/cft
$ git clone
$ cd docker-images/OracleDatabase

2.dockerのビルド ...

1.mongodbに接続
/usr/local/mongodb-3.0.4/bin/mongo 172.17.2.10:30000/admin

2.shardを追加
db.runCommand({̶ ...

SQL構文
SELECT SUM(CASE WHEN ID >=21 THEN 1 ELSE 0 END ) AS ‘COLA’,
SUM(CASE WHEN ID <=20 THE ...

例1
SELECT COUNT(DISTINCT CASE
WHEN addId >= 202 AND addId <= 258
THEN addId2 END)
FROM t_addres ...