2015/07/31

[Oracle to SQL Server Migration] TO_CHAR - Convert Datetime to String

›
In Oracle SELECT to_char ( MAX ( PRT_DATE ), 'yyyymmdd' ) FROM DBM000F1 WHERE FUNC_ID = 'DBM030R' AND RPT_ID = ...

[Oracle to SQL Server Migration] An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.

›
Problem Here is my original SQL statement in Oracle: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 SELECT B.MASTER_AGE, ORG_T...
2015/07/29

oracle.net.ns.NetException: Got minus one from a read call

›
Problem My web application environment is : Database: Oracle Application Server: JBoss As I startup JBoss, it show this error messag...
2015/07/27

[Oracle to SQL Server Migration] How to convert Oracle User-Defined Function to SQL Server

›
Here is my oracle user-defined function: 1 2 3 4 5 6 7 8 9 10 11 12 13 create or replace FUNCTION F_DBM_FIND_CODE_NM (PI_KI...
2015/07/26

2015/07 Kyoto

›
茶山站 清水寺 恵文社一乗寺店 京都文化博物館 南禪寺 鴨川納涼床 貴船神社 貴船流水麵線 鞍馬站

2015/07 Osaka

›
心齋橋筋 Harukas 300 - 展望台 Universal Studio Japan
2015/07/17

[MS SQL Server] How to insert an explicit value into datetime column

›
In Oracle, it would be wrote as bellows: 1 2 3 4 5 6 7 8 INSERT INTO AP_NTA.DBM030FA (STA_DATE,ORG_TYPE,AGE,AGE_NAME,MASTER_AGE,USER_I...

[Oracle to SQL Server Migration] Data Type Mapping for Oracle and MS SQL Server

›
Oracle data type SQL Server data type Alternatives BFILE VARBINARY(MAX) Yes BLOB VARBINARY(...