- 博客(9)
- 收藏
- 关注
RSS订阅原创 Get Dataset from Stored Procedure in Oracle
Stored Procedure (SP) can return data through one variable. We need to get dataset some times. Only one way to get the target is return cursor which can store dataset in SP. A cursor is a mechani
2014-09-13 19:01:03
519
原创 Pagination in Oracle
Pagination in Oracle Always we need to present dataset from Database in application. But the dataset is usually too huge to query all the records. So pagination is needed to improve performance.
2014-09-13 18:59:41
425
原创 Installation of Oracle 11g Business Intelligence Enterprise Edition
Installation of Oracle 11g Business Intelligence Enterprise Edition (OBIEE) together with Oracle Database Installation of Oracle Database Requirement Here we install Oracle 11g Business Int
2014-09-13 18:54:31
700
原创 Hadoop Note
Hadoop: Note" title="Hadoop Note" style="margin:0px; padding:0px; border:0px; list-style:none"> History: By Doug Cutting 2002: Nutch Started, but wouldn’t scale to the billions of page
2014-09-13 18:52:46
457
原创 Self Learning Note <The Data Warehouse ETL Toolkit> - Chapter 3 Extracting
Chapter 3 Extracting Part 1: The Logical Data Map Design Logical Before Physical 1. Have a plan – Document for data lineage (Alsocan be in database, if the numbers of tables is large , it is e
2014-09-11 23:17:58
435
原创 Hadoop V2.0.3 Cluster Setup Guide
Hadoop V2.0.3 Cluster Setup Guide 1 Single Node Cluster 1.1 Prerequisites 1.1.1 Sun Java installation Hadoop requires a working java installed, here I use the Java 1.7. Unzip
2014-08-30 21:48:57
786
原创 Hbase Cluster Setup Guide
Hbase Cluster Setup Guide Environment: 1. OS: Ubuntu 12.04.2 LTS 2. JAVA: JDK1.7 3. Hadoop: Hadoop 2.0.3 alpha 4. Maven: Maven3 5. Hbase: hbas
2014-08-30 20:39:08
432
原创 Set static IP for Linux
Get your ifconfig name for example (eth0, eth1, eth15). Here we use eth15 as exmple Add the following content to the file /etc/network/interfaces $: sudo vi /etc/network/interfaces address
2014-08-30 20:38:02
413
原创 Oracle Stored Procedure example
create or replace PROCEDURE ReadAuditItem(sRecordId IN VARCHAR2, sLoginId IN VARCHAR2 DEFAULT NULL, sFieldName IN VARCHAR2 DEFAULT NULL, sNewValue IN VARCHAR2 DEFAULT NULL, sOldValue IN VA
2014-08-30 20:35:20
480
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人