The name PL/SQL implies that it is a procedural language. But from 9i onwards PL/SQL started support for objects. The focus of procedural paradigm is on data structures like procedures, functions. On the other hand Object Oriented Programming (OOP) revolves around modeling the real world entities in the form of objects. Objects consist of attributes [...]
More for less is the inherent attribute of Oracle technology. Although Oracle is resource hungry software but once it is installed it can be made to use its resources optimally. One of the prime examples of this is shared server architecture. I am not going to discuss the shared server architecture anymore or how it [...]
Native Dynamic SQL! When I first heard the term the very first confusion raised in my mind was what Dynamic SQL is. Or at least what is static SQL so that I can differentiate between the two. Here is what I understood. When you know the tables and columns that you are referencing in your [...]
One of the efforts in the application development has been to isolate the information source mainly databases from programming logic. External routines are the natural solution for that. As the leading database in the world Oracle also provides integration with external routines. External procedures are the Oracle’s solution for incorporating the programming modules with your [...]
Backup and Recovery is the single most important task of a DBA. No matter how efficiently you do all the other things like installation, configuration, performance tuning etc. if your data is not safe then they are of no use. In an Oracle system the first thing you need to know is what to backup. [...]
Intersession communication means two user sessions communicating with each other. The user sessions can belong to the single user or they can be of two different users. Oracle Database 10g provides two methods for doing this.
First one is that in which there is a requirement of permanent or semi-permanent database structures for example tables, synonyms [...]
Would you please tell us something about you and your site?
I live with my wife Jutinder and two teenage daughters Ceris & Rianne in West Malling, a small village/town in the heart of Kent. After 18 years working for the BBC in Human Resources, I decided to leave in 2006 to reclaim my life. I [...]
Would you please tell us something about you and your site?
The positiveselfdevelopment.com was founded last October. Its purpose is to provide interesting blog posts and resources that help people develop themselves in order to realise their full potential as human beings..
I have been interested in the self development/self growth movement for a number of years and [...]
Would you please tell us something about you and your site?
I am a self taught artist, continually learning new techniques and finding new directions. My blog is about my creative life and the things I am passionate about – good design, films, music, and all things vintage.
Do you feel that you continue to grow in [...]
Also known as Process/Private Global Area in Oracle is the private area for each individual user process. It works for the server process. It is created with the creation of server process and is terminated with the abolition of server process. When the database is in dedicated mode there is a PGA for each server [...]
