数据库在oracle中,我的机器配置了odbc 32位,名为PPM,我已经创建了一个脚本,但需要帮助格式化计算的字段:
LIB CONNECT TO [PPM];
[SCRIPT]:
SQL Select NP.BUSINESS, NP.PLATFORM, NP.CATEGORY,
CASE WHEN IMPLE IS not NULL THEN IMPLE
WHEN CONTRACT IS not NULL THEN CONTRACT
WHEN ANALYSIS IS not NULL THEN ANALYSIS