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 [...]
Archive | Oracle Database RSS feed for this section
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 [...]
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 [...]
All about the Oracle RDBMS
Oracle is the most sophisticated database platform on the market. It is getting easier to do the lower level task, but they keep on adding features that you must keep up with so your developers can stay ahead of the competition. Oracle provides a great platform for both developers and the DBA. Here we will [...]
- What is a Schema in SQL Server 2005?
- Oracle 11g New Features for Developers
- Introduction to Oracle 11g Cursors
-
Using Oracle 11g Sequences
- So you want to be a Data Modeler?
