With the growing dimensions of data requirements, the nature of Information or ‘Data’ has taken multiple folds. The ‘Organizational data’ today cannot be expected in conventional and structural form, but it mostly exists in unstructured format. The database platform also must grow parallel to facilitate the able storage and sustain the growing developments.
Since the release of Oracle 8.1.6, analytic functions have emerged as a major extended strength of SQL language. Analytic functions address the problems like moving averages, cumulative sums, ranking, percentile and many other problems which are crucial for OLAP applications.
June 19, 2012 - Saurabh Gupta - Comments:
Since the time Oracle 11g has been released way back in the year 2003, it has waved a new exploring instinct among the database users. Till now, I observe the professionals engaged trying their hands out with Oracle 11g new features.
November 6, 2011 - Saurabh Gupta - Comments:
Oracle has provided several solutions to ensure and secure the database. An efficient security policy not only prevents the database against the database corruption or hacking threats but also minimizes the risk of unprivileged user access.
October 24, 2011 - Saurabh Gupta - Comments:
In a programming language, compiler plays a crucial role in execution of a program. Compiler is a language component which converts a source code, written using one of the interactive programming languages, into machine code, which the server can interpret and act upon.
July 6, 2011 - Saurabh Gupta - Comments:
Oracle 10g introduced conditional compilation feature in its second release. The conditional compilation feature enables a developer to impose conditions on the compiler. This implies that out of the complete source code of a program unit, only the part of code, which qualifies these conditions, would be compiled.
June 28, 2011 - Saurabh Gupta - Comments:
Encapsulation and modularity are the few of the generic and recommended language features, which enhance efficiency and scalability of the language in the application. Oracle database language implements these features through stored subprograms.
June 7, 2011 - Saurabh Gupta - Comments:
Oracle 11g release has introduced a new property of an Index i.e. Visibility. Before the world saw 11g release, an index was always created and existed in visible mode. But now, as per the fresh feature in Oracle 11g, an index may exist in Invisible Mode too.
May 27, 2011 - Saurabh Gupta - Comments:
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 new column using UPDATE statement. Refer the example code ….
May 15, 2011 - Saurabh Gupta - Comments:
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 native compilation was taken as one of the revolutionary changes…
April 25, 2011 - Saurabh Gupta - Comments:
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. Now, database connection passwords could be case sensitive. Two new…
April 24, 2011 - Saurabh Gupta - Comments:
June 19, 2012 - 0 Comment
January 17, 2012 - 0 Comment
November 6, 2011 - 0 Comment
October 24, 2011 - 0 Comment
September 4, 2011 - 0 Comment
August 16, 2011 - 0 Comment
August 10, 2011 - 0 Comment
July 6, 2011 - 0 Comment
June 28, 2011 - 0 Comment
June 17, 2011 - 0 Comment