Materialized View Concepts and Architecture
Oracle Materialized View concepts and architecture in Oracle9i Database Online Documentation. The chapter describes the use of materialized views, types, mechanism and ways of refreshing oracle materialized...
http://download.oracle.com/docs/cd/B10501_01/server.920/a96567/repmview.h
Oracle Materialized View concepts and architecture in Oracle9i Database Online Documentation. The chapter describes the use of materialized views, types, mechanism and ways of refreshing oracle materialized...http://download.oracle.com/docs/cd/B10501_01/server.920/a96567/repmview.h
Oracle Analytic functions
Analytic functions in Oracle 8i and 9i are designed to resolve such data processing problems as calculation of moving average, running totals, finding percentages within a group. Analytic functions compute an aggregate value based on a group of rows. ...
http://psoug.org/reference/analytic_functions.html
Analytic functions in Oracle 8i and 9i are designed to resolve such data processing problems as calculation of moving average, running totals, finding percentages within a group. Analytic functions compute an aggregate value based on a group of rows. ...http://psoug.org/reference/analytic_functions.html
Analytic functions by example
The tutorial provides a clear, thorough concept of analytic functions and its various options by a series of simple, concept building examples. The article is addressed to SQL coders (with knowledge of basic Oracle SQL with sub-querying, joins and grouping)...
http://www.orafaq.com/node/55
The tutorial provides a clear, thorough concept of analytic functions and its various options by a series of simple, concept building examples. The article is addressed to SQL coders (with knowledge of basic Oracle SQL with sub-querying, joins and grouping)...http://www.orafaq.com/node/55
Oracle Discoverer blog
Discoverer blog with tutorials which help learning Oracle Discoverer. The articles cover installation and setup guide, Discoverer integration with BI Publisher, Discoverer OLAP and Excel AddIn, overview of Oracle Data Warehousing solutions and a best...
http://oraclebi.blogspot.com/search/label/Discoverer
Discoverer blog with tutorials which help learning Oracle Discoverer. The articles cover installation and setup guide, Discoverer integration with BI Publisher, Discoverer OLAP and Excel AddIn, overview of Oracle Data Warehousing solutions and a best...http://oraclebi.blogspot.com/search/label/Discoverer
Oracle PL/SQL, MySQL, SQL Server tutorials
PL/SQL Tips and programming examples. The examples include tasks like sending email in PLSQL, creating random numbers, Oracle Internet Directory, long deletes, integration with operating system. The examples are clear and easy to understand and implement....
http://www.idevelopment.info/
PL/SQL Tips and programming examples. The examples include tasks like sending email in PLSQL, creating random numbers, Oracle Internet Directory, long deletes, integration with operating system. The examples are clear and easy to understand and implement....http://www.idevelopment.info/
Oracle articles and FAQ
Oracle data warehousing articles and FAQ's with broad information and comments. We recommend reading the following articles: Indexing an Oracle Data Warehouse to improve performance Partitioning in Oracle 11g - use of partitioning to improve query performance...
http://www.orafaq.com/articles/warehouse
Oracle data warehousing articles and FAQ's with broad information and comments. We recommend reading the following articles: Indexing an Oracle Data Warehouse to improve performance Partitioning in Oracle 11g - use of partitioning to improve query performance...http://www.orafaq.com/articles/warehouse
Getting Started with Discoverer
The getting started with Oracle Discoverer tutorial is a great site to start learning Oracle Business Intelligence. The tutorial uses a small database that contains information about a fictitious business which puts it into a real-life context. It is rich in...
http://35.8.180.84/discwb4/doc/tutorial/GetStart.html
The getting started with Oracle Discoverer tutorial is a great site to start learning Oracle Business Intelligence. The tutorial uses a small database that contains information about a fictitious business which puts it into a real-life context. It is rich in...http://35.8.180.84/discwb4/doc/tutorial/GetStart.html
How to create an Oracle Analytic Workspace
The tutorial shows how to populate a samle OLAP Analytic Workspace with dimensions and cube objects using Analytic Workspace Manager - Oracle AWM. The tutorial is based on a fictional business scenario (a computing company) with a model compound of 21 oracle...
http://www.oracle.com/technetwork/tutorials/index.html
The tutorial shows how to populate a samle OLAP Analytic Workspace with dimensions and cube objects using Analytic Workspace Manager - Oracle AWM. The tutorial is based on a fictional business scenario (a computing company) with a model compound of 21 oracle...http://www.oracle.com/technetwork/tutorials/index.html
Ask Tom Oracle Questions and Answers
AskTom is a rich knowledge base for working with Oracle databases. People ask questions related to Oracle or describe problems they are facing. Tom answers those questions which then can be reviewed by the users which results in building a knowledge base for...
http://asktom.oracle.com
AskTom is a rich knowledge base for working with Oracle databases. People ask questions related to Oracle or describe problems they are facing. Tom answers those questions which then can be reviewed by the users which results in building a knowledge base for...http://asktom.oracle.com
Oracle SQL Hints
A good guide on SQL query optimization by using SQL Hints in an Oracle database. The tutorial shows why the hints are useful and when Oracle hints should be used instead of the default Oracle optimizer. The oracle hints are categorized into groups such as...
http://www.adp-gmbh.ch/ora/sql/hints/index.html
A good guide on SQL query optimization by using SQL Hints in an Oracle database. The tutorial shows why the hints are useful and when Oracle hints should be used instead of the default Oracle optimizer. The oracle hints are categorized into groups such as...http://www.adp-gmbh.ch/ora/sql/hints/index.html
Hyperion reporting and analysis Documentation
Reporting and Analysis section of the online Hyperion Enterprise Performance Management System Documentation. There are many documents in HTML and PDF format on various Hyperion products, such as: Dashboard Development Services, Hyperion Financial Reporting,...
http://download.oracle.com/docs/cd/E10530_01/doc/nav/portal_4.htm
Reporting and Analysis section of the online Hyperion Enterprise Performance Management System Documentation. There are many documents in HTML and PDF format on various Hyperion products, such as: Dashboard Development Services, Hyperion Financial Reporting,...http://download.oracle.com/docs/cd/E10530_01/doc/nav/portal_4.htm