Oracle
zhangfaji
这个作者很懒,什么都没留下…
展开
-
Oracle行转换列SQL语句
select fmonth,sum(decode(factionid,1,fcount,0)) as factionid1,sum(decode(factionid,2,fcount,0)) as factionid2 from ( select fmonth,factionid,count(*) as fcount from ( select a.*,to_cha原创 2006-12-08 22:57:00 · 741 阅读 · 0 评论 -
Oracle常用脚本
--Create the tablespacecreate tablespace coverm datafile D:/oracle/oradata/lyszdn/coverm.dbf size 20m minimum extent 500k -- Create the user create user coverm identified by coverm09898 defau原创 2006-12-08 23:03:00 · 469 阅读 · 0 评论 -
Oracle bat备份文件
set yr=%date:~0,4%set mo=%date:~5,9%set mo=%mo:~0,2%set dy=%date:~8,10%set name=%yr%_%mo%_%dy%exp sms/sms@cesoft file=d:/%name%.dmp log=d:/exp.log原创 2006-12-08 23:07:00 · 560 阅读 · 0 评论