Following are the list PL/SQL Features introduced in Oracle11g
Automatic subprogram inlining
A continue statement
A cross-session PL/SQL function result cache
Dynamic SQL enhancements
Mixed, named, and positional notation SQL calls
A multiprocess connection pool
A PL/SQL Hierarchical Profiler
That the PL/SQL Native Compiler now generates native code
PL/Scope
Regular expression enhancements
A SIMPLE_INTEGER datatype
Direct [...]
Continue reading about PL/SQL Features Introduced in Oracle11g
The difference between RANK() and DENSE_RANK() is that RANK() leaves gaps in the ranking sequence when there are ties. Let us see this function through an example.
Continue reading about SQL Tutorial : Using RANK() and DENSE_RANK()
In subqueries, regardless of whether one row or multiple rows are returned, each of these rows contains only one column worth of data to compare to the main query level. The main query can be set up to handle multiple columns in each row returned, too.
For example
select deptno,ename,job,sal, from emp [...]
Continue reading about SQL TIPS : Writing Multiple Column Subqueries
In this tutorial we can see how to convert rows into columns using Structured Query language SQL. We cover this tutorial from the basic steps i.e creating tables and inserting values into the table so that it can be useful for basic users as well
Continue reading about SQL Tutorial : Converting Rows to Columns
Following are some of the items that we need to keep in mind while Reviewing Java Code. The following checklist holds a list of activities that needs to be carried out while Reviewing Java Code.
There are eleven different types issues that have been discussed here and the critical areas in which review should be done [...]
Oracle Warehouse Builder is Primarily a tool to build, deploy, and run ETL (Extract, Transform, Load), relational and dimensional modeling, data quality, data auditing, and full lifecycle management of data and metadata. OWB powers ETL and data quality integrated with the Oracle Database.
Continue reading about OWB Oracle Warehouse Builder an Introduction
UTL_MAIL Package in oracle 10g is used to send email programmatically from Oracle PL/SQL procedures. This tutorial explains how to use the package to send email.
primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key
Oracle PL/SQL: Oracle System Tables. Below is an alphabetical listing of the Oracle system tables that are commonly used.
A cursor is a mechanism by which you can assign a name to a “select statement” and manipulate the information within that SQL statement. This tutorial is a continuity of Oracle PL/SQL Cursors which discuses some basic functionalities of PL/SQL Cursors.
