Concepts for Developing Oracle 11g RAC enabled Applications

Introduction Real Application Clusters (RAC) allows multiple computers to run Oracle software simultaneously while accessing a single database, therefore providing a clustered database. In the previous non-RAC oracle database, a single instance accesses a single database. And we know that clustering is the task of assigning a set of objects into groups. In an Oracle […]

Continue Reading 0

Master Advanced PL/SQL concepts with “Oracle Advanced PL/SQL Developer Professional Guide”

The Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book aims to be a sure selection for the Associate level Oracle professionals aspiring for Professional level. The topics covered and demonstrated are in line with the Oracle University prescription for Oracle Professional certification, which justify the […]

Continue Reading 5

What is a Database?

For the technical purpose of database developers and administrators, a database is simply a collection of operating system files. Database files are normally stored in a proprietary binary format that can only be mounted by an instance of the relational database software that created them. The purpose of the database instance is to manage and deliver […]

Continue Reading 0

Looking forward to SQL Server 2012

I finally got around to installing SQL Server 2012 RC 0 on VMware Fusion 4 yesterday. Like a kid on Christmas, I started looking for the enhancements that do not get much marketing attention, but will improve my development workflow or put an end to some administration pains. This is what I found so far: […]

Continue Reading 0

Oracle 11g Pivot Functions

Data mining, processing and its presentation are the key activities in a production environment. The views and analytic integrals of the information through multiple spectacles can help in better business forecasting and strategic implementations. This innovative exercise of creating varying views might involve aggregation, data transposing, or cross tabulation reporting. Data Pivoting, one of the […]

Continue Reading 2

Powered By Mekhano Media