select * from (select pro_id, sum(decode(month, '01', summ)) one,
sum(decode(month, '02', summ)) two,
sum(decode(month, '03', summ)) three,
sum(decode(month, '04', summ)) four,
sum(decode(month, '05', summ)) five,
sum(decode(month, '06', summ)) six,
sum(decode(month, '07', summ)) seven,
sum(decode(month, '08', summ)) eight,
sum(decode(month, '09', summ)) nine,
sum(decode(month, '10', summ)) ten,
sum(decode(month, '11', summ)) eleven,
sum(decode(month, '12', summ)) twelve
from (select r.pro_id, to_char(r.rabi_date, 'mm') as month,
注: 这是个人看Oracle视频时写下的笔记, 多有错误, 望各位切勿吝惜赐教.
1. Dos
下登陆超级管理员
：
sqlplus sys/
密码
as sysdba
2.
更改管理员
：
alter user scott account unlock;
3.
数据的备份
.
A
导出
:
Cmd
下
: ......
