- 博客(9)
- 收藏
- 关注
原创 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
482
原创 Pagination in Oracle
Pagination in OracleAlways 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
386
原创 Installation of Oracle 11g Business Intelligence Enterprise Edition
Installation of Oracle 11g Business Intelligence Enterprise Edition (OBIEE) together with Oracle DatabaseInstallation of Oracle DatabaseRequirementHere we install Oracle 11g Business Int
2014-09-13 18:54:31
651
原创 Hadoop Note
Hadoop:Note" title="Hadoop Note" style="margin:0px; padding:0px; border:0px; list-style:none">History:By Doug Cutting2002: Nutch Started, but wouldn’t scale to the billions of page
2014-09-13 18:52:46
419
原创 Self Learning Note <The Data Warehouse ETL Toolkit> - Chapter 3 Extracting
Chapter 3 ExtractingPart 1: The Logical Data MapDesign Logical Before Physical1. 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
394
原创 Hadoop V2.0.3 Cluster Setup Guide
Hadoop V2.0.3 Cluster Setup Guide1 Single Node Cluster1.1 Prerequisites1.1.1 Sun Java installationHadoop requires a working java installed, here I use the Java 1.7.Unzip
2014-08-30 21:48:57
736
原创 Hbase Cluster Setup Guide
Hbase Cluster Setup GuideEnvironment:1. OS: Ubuntu 12.04.2 LTS2. JAVA: JDK1.73. Hadoop: Hadoop 2.0.3 alpha4. Maven: Maven35. Hbase: hbas
2014-08-30 20:39:08
392
原创 Set static IP for Linux
Get your ifconfig name for example (eth0, eth1, eth15). Here we use eth15 as exmpleAdd the following content to the file /etc/network/interfaces$: sudo vi /etc/network/interfacesaddress
2014-08-30 20:38:02
361
原创 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
439
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人