ZT sqlplus输出变量到shell
原文:http://blog.csdn.net/edwzhang/archive/2009/12/16/5016998.aspx有时因工作需要,得写一些脚本,都是shell和sqlplus混合的。一般情况下,shell变量带入到sql脚本,比较方便,但是把sql的一些结果,输出给shel...
In-Database MapReduce (Map-Reduce)
The Map-Reduce model has become a popular way for programmers to describe and implement parallel programs. These custom map-reduce programs are often used to process a large data set in parallel. This...
MapReduce + Oracle = Tablefunctions
One of the things we did do at Openworld was a handson session showing how to implement a mapreduce system on top of a generic Oracle Database. This is based on the original posts on this blog, which ...
Oracle’s Lag in MS SQL Server 2005
I am currently porting our new database from Oracle 10g to MS SQL Server 2005, and I have it all done except the views that use the Oracle LAG and LEAD functions (non-ANSI).What these functions pr...