Oracle酷站推荐! http://www.oracle.com.cn也是一个不错的论坛啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 除了oracle的網站外--------->>>遇到疑難問題,我都會到這里找找:http://www.orafaq.com/faq2.htm還有這里:http://asktom.oracle.com/pls/ask/f?p=4950:1:一個專業的網站,你可以得到非常專業的解答:http://www.experts-exchange.com/Databases/Oracle/Q_20484585.htmlhttp://oracle.ittoolbox.com/groups/groups.asp?v=ORACLE-DB-L 我给的网站绝对超一流http://www.dbapool.com/http://www.dbaclick.com/ 55555..... 我就知道csdn! http://www.ncn.cn/http://www.itpub.net/http://www.oraclefan.net/都是很好的值得去的中文网站 www.csdn.com.cnwww.oradb.netwww.itpub.netwww.orafan.com http://www.oracle.com.cnhttp://www.orafaq.comhttp://www.oradb.nethttp://www.oraclefan.ne上面的几个我去过的,觉得很不错:) http://www.engin.umich.edu/caen/wls/software/oracle/index.htm 很好metalink.oracle.com SQL> select * from inout;THEDATE INCOME OUTGO--------- ---------- ----------01-MAR-00 50 3002-MAR-00 45 6005-MAR-00 60 1005-MAR-00 60 10SQL> select every_thedate,sum_income,sum_outgo,add_surplus 2 from (select every_thedate,nvl(sum(income),0) sum_income,nvl(sum(outgo),0) sum_outgo, 3 sum(nvl(sum(income),0)-nvl(sum(outgo),0)) over(order by every_thedate) add_surplus 4 from (select nvl((select min(thedate) from inout ),sysdate) + rownum -1 every_thedate 5 from emp where rownum <= nvl((select max(thedate) - min(thedate) 6 from inout ),sysdate) + 1 ) a, 7 inout b 8 where a.every_thedate = b.thedate(+) 9 group by every_thedate) 10 /EVERY_THE SUM_INCOME SUM_OUTGO ADD_SURPLUS--------- ---------- ---------- -----------01-MAR-00 50 30 2002-MAR-00 45 60 503-MAR-00 0 0 504-MAR-00 0 0 505-MAR-00 120 20 105SQL> www.cnoug.orgwww.hotsos.comwww.orapub.comwww.ixora.com.au如果自认是高手或对oracle internal感兴趣,可以去这些网站看看 http://www.aspsky.net/article/list.aspx?classid=5&nclassid=20 有什么方法可以快速列出我的收藏夹里的指向? Ask Tom Home.url Chinese Oracle User Group.url http--www.oraclefan.net-.url ITPUB论坛 - powered by itpub.net.url Oracle Inisialization Parameters.url Oracle Technology Network.url Oracle Underground Frequently Asked Questions.url Oracle9i Database Online Documentation (Release 9.0.1).url ORACLE中文技术论坛.url Oracle技术网—http--www.oradb.net-.url Oracle杂货店.url [ 永远的UNIX 数据库 Oracle ].url ★永远的UNIXUNIX技术资料的宝库★ -- Linux,FreeBSD,Solaris,SCO,HP-UX,IBM-AIX....url 天极网---软件频道.url 数据库系统.url 时代朝阳数据库技术中心.url 聚贤庄IT联盟 - WWW.NCN.CN - Oracle、INFORMIX、SYBASE、DB2、HP-UX、AIX、TRU64 UNIX、SOLARIS、LINUX、ERP、SAN 中间件.url CertCities.com Oracle.url Oracle Documentation.url 欢迎访问oracle技术站.url Welcome to dbapool.url dbaclick Oracle DBA forums, news, scripts and documentation.url DBAsupport.com The Knowledge Center for Oracle Professionals.url 找不到服务器.url Oracle performance tuning = Ixora.url tahiti.oracle.comasktom.oracle.commetalink.oracle.comwww.cnoug.orgwww.itpub.net metalink.oracle.com,oracle官方论坛 一个oracle的查询问题,如何把数据均匀分配 PL/SQL 过程或函数中如何调用DOS命令? oracle与access通讯的问题。 数据库启动不能,高手请进! oracle中to_timestamp取毫秒精度问题 咋样把一张表A里的记录在某字段修改后插入到表A, 含BLOB字段的表,MOVENEXT()出错 关于id号的问题! 一个有关子查询的问题, 请oracle817 for linux 应该如果设置才能自动启动? 送分题,快来! 我打开windows2003的防火墙后,发现客户端连数据库连不上了!!请各位帮忙!
http://www.orafaq.com/faq2.htm
還有這里:
http://asktom.oracle.com/pls/ask/f?p=4950:1:
一個專業的網站,你可以得到非常專業的解答:
http://www.experts-exchange.com/Databases/Oracle/Q_20484585.html
http://oracle.ittoolbox.com/groups/groups.asp?v=ORACLE-DB-L
http://www.dbapool.com/
http://www.dbaclick.com/
www.oradb.net
www.itpub.net
www.orafan.com
metalink.oracle.com
--------- ---------- ----------
01-MAR-00 50 30
02-MAR-00 45 60
05-MAR-00 60 10
05-MAR-00 60 10SQL> select every_thedate,sum_income,sum_outgo,add_surplus
2 from (select every_thedate,nvl(sum(income),0) sum_income,nvl(sum(outgo),0) sum_outgo,
3 sum(nvl(sum(income),0)-nvl(sum(outgo),0)) over(order by every_thedate) add_surplus
4 from (select nvl((select min(thedate) from inout ),sysdate) + rownum -1 every_t
hedate
5 from emp where rownum <= nvl((select max(thedate) - min(thedate)
6 from inout ),sysdate) + 1 ) a,
7 inout b
8 where a.every_thedate = b.thedate(+)
9 group by every_thedate)
10 /EVERY_THE SUM_INCOME SUM_OUTGO ADD_SURPLUS
--------- ---------- ---------- -----------
01-MAR-00 50 30 20
02-MAR-00 45 60 5
03-MAR-00 0 0 5
04-MAR-00 0 0 5
05-MAR-00 120 20 105SQL>
www.hotsos.com
www.orapub.com
www.ixora.com.au
如果自认是高手或对oracle internal感兴趣,可以去这些网站看看
Chinese Oracle User Group.url
http--www.oraclefan.net-.url
ITPUB论坛 - powered by itpub.net.url
Oracle Inisialization Parameters.url
Oracle Technology Network.url
Oracle Underground Frequently Asked Questions.url
Oracle9i Database Online Documentation (Release 9.0.1).url
ORACLE中文技术论坛.url
Oracle技术网—http--www.oradb.net-.url
Oracle杂货店.url
[ 永远的UNIX 数据库 Oracle ].url
★永远的UNIXUNIX技术资料的宝库★ -- Linux,FreeBSD,Solaris,SCO,HP-UX,IBM-AIX....url
天极网---软件频道.url
数据库系统.url
时代朝阳数据库技术中心.url
聚贤庄IT联盟 - WWW.NCN.CN - Oracle、INFORMIX、SYBASE、DB2、HP-UX、AIX、TRU64 UNIX、SOLARIS、LINUX、ERP、SAN 中间件.url
CertCities.com Oracle.url
Oracle Documentation.url
欢迎访问oracle技术站.url
Welcome to dbapool.url
dbaclick Oracle DBA forums, news, scripts and documentation.url
DBAsupport.com The Knowledge Center for Oracle Professionals.url
找不到服务器.url
Oracle performance tuning = Ixora.url
asktom.oracle.com
metalink.oracle.com
www.cnoug.org
www.itpub.net