Oracle 11g SQL New Features

In continuation to my last tutorial on PL/SQL enhancements, I have compiled the list of enhancement pertaining to SQL. Similar to PL/SQL, Oracle had done considerable enhancements in SQL to raise performance level from instrumental to advisory. In the tutorial, we shall go through the performance oriented features, fresh additions and language enhancements. Performance improvements a. Alter table to add columns with default value In Oracle 11g, we can alter a table to add a column with a default value. Earlier, a developer used to update the value for the… Read More

PL/SQL Native Compilation in Oracle 11g

During the introduction of Objects and Types in Oracle 8 release, PL/SQL was referred as procedural and object oriented language. While Oracle 9i and 10g were more concentrated on the sharpening of the object oriented model of Oracle, Oracle 11g aims at evolving PL/SQL from interpreted language to natively compiled language. In the tutorial, we shall see the changes made to achieve native compilation and its post application effects. Interpreted to Native Compilation: A Tour Native compilation of program units was first introduced in Oracle 9i release 1. Introduction of… Read More

Oracle 11g PL/SQL New Features

The tutorial lists the major PL/SQL additions and enhancements covered in Oracle 11g. The features described here are based on their utility in a development environment. SQL* Plus Stepped Down and Passwords made Case Sensitive SQL* Plus is no more the part of Oracle home family. This step has been taken to recommend the use of SQL Developer. SQL Developer version 3.0 is the latest release from Oracle, in which all the earlier reported bugs were resolved. Besides, developers can still optionally setup SQL* Plus environment on command line prompt.… Read More

Oracle PL/SQL Tutorial

This introductory tutorial to PL/SQL will help you to understand the basic concepts of PL/SQL.  Review the following tutorials and practice the sample SQL Statements on your local Oracle Database. Please note that you must learn these basic things before we actually start getting in to Advanced Oracle Concepts in the OCP Certification track. SQL, PLSQL, and SQL SQL *Plus – Introduction We are excited to let you know that we are launching shortly The New Technology Learning Series. We will be starting with Oracle 9i: SQL, PLSQL, and SQL… Read More

Download Free Oracle SQL Developer

Download Free Oracle SQL Developer Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, edit and debug PL/SQL statements, manipulate and export data, and view and create reports. You can connect to Oracle databases, and you can connect to selected third-party (non-Oracle) databases, view metadata and data, and migrate these databases to Oracle. Oracle SQL Developer 3.0 Early Adopter 4 now available. Be a part of the Early Adopter… Read More