解决方案 »
- 存储过程写法
- 新手请教一个oracle安装./runInstaller:line 47的问题,很着急。
- 急需OWB文檔, 高分相贈
- 触发器中如何提交数据?着急。。
- 一个非常难的查询问题,急!!!!!!!!!!
- ORCALE客户端连接问题。
- 能否在视图上建触发器?
- 错误:ORA-01033 ORACLE initialization or shutdown in progress
- 请问Linux 64位下安装oracle 10g提示这个怎么解决
- oracle中如何通过查询某张表的某个字段被存储过程或函数使用
- oracle数据库in语句中用regexp_replace的问题
- 仓库进出库系统数据库设计
WITH t1 AS (SELECT '张三' Name, 'A' "LEVEL", 1 Month FROM DUAL
UNION ALL
SELECT '李四', 'B', 2 Month FROM DUAL
UNION ALL
SELECT '王五', 'C', 3 Month FROM DUAL
UNION ALL
SELECT '张三', 'B', 2 Month FROM DUAL
UNION ALL
SELECT '李四', 'B', 1 Month FROM DUAL
UNION ALL
SELECT '王五', 'C', 1 Month FROM DUAL
UNION ALL
SELECT '张三', 'B', 3 Month FROM DUAL
UNION ALL
SELECT '李四', 'B', 3 Month FROM DUAL
UNION ALL
SELECT '王五', 'B', 2 Month FROM DUAL)
SELECT name,
wm_concat ("一月份") "一月份",
wm_concat ("二月份") "二月份",
wm_concat ("三月份") "三月份"
FROM (SELECT name,
DECODE (month, 1, "LEVEL") "一月份",
DECODE (month, 2, "LEVEL") "二月份",
DECODE (month, 3, "LEVEL") "三月份"
FROM t1)
GROUP BY name
WITH t1 AS (SELECT '张三' Name, 'A' "LEVEL", 1 Month FROM DUAL
UNION ALL
SELECT '李四', 'B', 2 Month FROM DUAL
UNION ALL
SELECT '王五', 'C', 3 Month FROM DUAL
UNION ALL
SELECT '张三', 'B', 2 Month FROM DUAL
UNION ALL
SELECT '李四', 'B', 1 Month FROM DUAL
UNION ALL
SELECT '王五', 'C', 1 Month FROM DUAL
UNION ALL
SELECT '张三', 'B', 3 Month FROM DUAL
UNION ALL
SELECT '李四', 'B', 3 Month FROM DUAL
UNION ALL
SELECT '王五', 'B', 2 Month FROM DUAL)
SELECT name,
Max(DECODE (month, 1, "LEVEL")) "一月份",
Max(DECODE (month, 2, "LEVEL")) "二月份",
Max(DECODE (month, 3, "LEVEL")) "三月份"
FROM t1 GROUP BY NAME