解决方案 »
- updata 语句,疑惑
- 如何取出7天前到当前日期的所有记录?
- 手动建库ORA-01092: ORACLE instance terminated. Disconnection forced!!!
- 问个关于oracle很基础的问题啊
- 关于简单的存储过程
- 怎样才能简化这条PLSQL语句?
- 怎么样把77.8.9转换成1977-08-09?
- win2003,9i,在空间USER上建了一个用户user1/pass1,在这个用户上建了一个表,我想备份?但出现问题?
- CLOB类型的建表错误
- UNIX机器上安装Oracle 12c 报错“Failed to access the temporary location.”
- oracle创建了一个无密码验证的dblink,是怎么通过无密码验证的
- oralce联合子查询的疑惑
select a.BUSI_KEY||'|'||
max(decode(info_id, 'A_TERM_MODEL' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'A_TERM_OFFER' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'A_TERM_TYPE' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'A_TRAN_HOUSE' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'BILL_CYCLE' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'BILL_NUM' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'END_ADDR' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'LINE_END' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'LINE_SCOPE' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'LINE_START' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'SEVER_BEGIN_DATE' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'SEVER_END_DATE' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'SPECIAL_LINE_TYPE' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'SPEED_TYPE' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'START_ADDR' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'USE_PROPERTY' , nvl(info_val,'0'),'0')) ||'|'||
max(decode(info_id, 'USE_PURPOSE' , nvl(info_val,'0'),'0'))
from crm01_app.ucs_subs_other_info a where a.INFO_GRP_ID = 'gw_9310' group by a.BUSI_KEY;