Oracle PL/SQL Language Pocket Reference

EBook Description: The purpose of this pocket reference is to help PL/SQL users find the syntax of specific language elements. It is not a self-contained user guide; basic knowledge of the PL/SQL programming language is required.

This guide will attempt to show you how to create stored procedures for the World Wide Web. As I was in the middle of writing this guide, I realized it was about 10 times more lengthy than what I intended. The interface you will be using is slick, writing stored procedures is a snap, and you can do some marvelous things in a very short time. But, there is lots of good information in this guide, and I wanted to be as complete as possible.

PL SQL

Oracle is probably the most popular enterprise database server at the moment. This is the server that powers eBay on the web and countless data warehouses and VLDBs around the world. Oracle is suited for all applications from OLTP to Data Warehousing.

Oracle 9i

Online Free Tutorial

Oracle 10g

Online Tutorial

SQL server 2005

Microsoft SQL Server 2005 provides the database developer the opportunity to locate programming code in native formats or create server-driven complex systems. The .NET framework, in combination with the SQL Server 2005, delivers the functionality of the powerful class library in combination with modern programming languages. Common Language Runtime (CLR) is used to code procedures, triggers and functions within the chosen language in the .NET framework. Using object-oriented constructs such as structured exception handling, namespaces, classes and arrays assist the programmer in effectively handling procedural issues when programming with SQL Server 2005.

Data Recovery

Data Recovery is exactly what it sounds like - a way to recover important information that was lost from a computer crash, hard disk malfunction, or virus attack. No matter the scale, big corporation database recovery or single user retrieval of files from spontaneous �deleting�, data recovery is an important and necessary part of any operating system. Data Recovery software can be developed, installed and removed from existing systems to retrieve lost data or partial data and minimize damage caused to the system. The goal of data recovery is perfection, as in, not losing a single byte of infor

Data Mining

Data Mining is a complex subject that describes a type of database application used to search large amounts of data for patterns using specific tools. Advanced statistical methods and tools such as classification, association rule mining and cluster analysis search large volumes of data for previously unknown relationships within the data. Data Mining can be used to decipher trends in a wide variety of fields such as computer science, the marketing and advertising of goods, services or products, artificial intelligence research, biological sciences and high-level government intelligence.

Data Warehousing

A data warehouse consists of a computer database responsible for the collection and storage of information for a specific organization. This collection of information is then used to manage information efficiently and analyze the collected data. Although data warehouses vary in overall design, majority of them are subject oriented, meaning that the stored information is connected to objects or events that occur in reality. The data provided by the data warehouse for analysis provides information on a specific subject, rather than the functions of the company and is collected from varying sources into one unit having time-variant.

Learn SQL

earn SQL By topics

Concurrency Control And Recovery in Database Systems

Concurrency Control And Recovery in Database Systems

• Free IAS eBooks
• Free GRE eBooks
• Free MBA eBooks
• Free GATE eBooks