Oracle Sequences have efficiently fulfilled the requirement of generation of unique numbers in a table. They can be casted as Primary Key of a table. In the current article, we shall note the applications of a Sequence, its features and behavior in various scenarios. Introduction Oracle introduced Sequences in its sixth release (Oracle 6) to [...]
Oracle 11g New Features for Developers
With each and every release, Oracle has tried to provide best database services to the users across the world. Over the period of time and releases, it has become more intelligent, efficient, strong, reliable, flexible and secure. Introduction Oracle 11g Release 2 is the latest release of Oracle in 11g series. Unlike the last release [...]
Oracle Server Process
Server Process A server process handles the connection to the database on behalf of the client program and performs one or more of the following: Parse and run SQL statements and PL/SQL issued through the application/client. Read necessary data blocks from datafiles on disk into the shared database buffers of the SGA. Return results in such [...]
Oracle Software Code Area
Software Code Areas Oracle code is stored in a software area that is typically at a different location from users’ programs. Software areas are read only, usually static in size, and can be installed shared or nonshared. When possible, Oracle code is shared so that all Oracle users can access it without having multiple copies [...]
Basic UNIX Commands for the DBA
A collection of commonly used UNIX commands by the Oracle Database Administrator. File Manipulation Action Command Example list file contents cat cat myfile append to a file cat cat myfile >>newfile combine two files cat cat myfile1 myfile2 >newfile create a file cat cat >newfile copy a file cp cp myfile newfile create a file [...]
The History of PL/SQL
PL/SQL is Oracle’s Procedural Language extension to SQL. It is loosely based on Ada (a variant of Pascal developed for the US Dept of Defense). PL/SQL was first released in 1992 as an optional extension to Oracle 6. PL/SQL is now a technology present in most Oracle servers and products. PL/SQL Version: 1.0 - 1991 [...]
A General Philosophy for Data Modeling
The design of any application depends on the foundation of its data model. We must all accept the simple fact that the decisions made during the data modeling phase will determine the overall success of the application. Before we address any specific data modeling topics or problems, we must talk about the philosophy that will provide the [...]
How do I get a Record Set from a Stored Procedure in Oracle
Developers that are familiar with using MS SQL Server eventually get the opportunity to work on a project that is Oracle based. This opportunity sometimes becomes an extremely frustrating time due to the philosophical differences in the approach to database development. I believe it is hard for most developers to transition between the two database platforms, not [...]
Oraclenotes.com is now DBAnotes.com
If you are looking for Oraclenotes.com, Do Not Panic, you are in the right place. Today we have finally made the switch from Oraclenotes.com to DBAnotes.com. Oraclenotes.com was a stand-alone website since 1999, and we appreciate all of the support we received over the past 10 years. It was a difficult decision to consolodate the two [...]
What is a Schema in SQL Server 2005?
What is a Schema? In Microsoft SQL Server 2005, a schema is a collection of objects adhering to the ANSI SQL-92 standard. The ANSI SQL-92 standard defines a schema as a collection of database objects that are owned by a single principle and form a single namespace. All objects within a schema must be uniquely [...]
- What is a Schema in SQL Server 2005?
- Oracle 11g New Features for Developers
- Introduction to Oracle 11g Cursors
- So you want to be a Data Modeler?
- Using Triggers and Compound Triggers in Oracle 11g
