Jul/090
What is Oracle PLSQL
PL/SQL is Oracle’s SQL++ programming language providing structure and flow control extensions to SQL. The name PLSQL is derived from the term “Procedural Language extensions to SQL”.
On its own, SQL enables you to specify what you want done but not how it is done. However, you often need more control over how data is retrieved and manipulated and this is where PL/SQL comes in.
The procedural capabilities combined with standard SQL in Oracle PLSQL gives developers far more control of how their SQL statements interact with the database and makes using PL/SQL an excellent alternative to developing applications in other languages such as Java or C or VB.
The language itself is modeled on Ada, so Java/C/C++ programmers will find the syntax rather strange and probably won’t like the single”=” being used for comparison, but anyone who’s used Pascal or Ada or Modula2 will fell right at home.
PL/SQL is not a pure object-oriented language like Java or Ada, but it does support some obect-oriented features such as classification, polymorphism and, in the later versions, inheritance.
No comments yet.
Sorry, the comment form is closed at this time.
No trackbacks yet.