Oracle 11g pl/sql tutorial pdf

PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. PL/SQL Data Types. 3.1 SQL Data Types 3-2 3.1.1 Different Maximum Sizes 3-2 3.1.2 Additional PL/SQL Constants for BINARY_FLOAT and BINARY_DOUBLE 3-3. v. Assigning Values to Variables with the SELECT INTO Statement2-26. Assigning Values to Variables as Parameters of a Subprogram2-27. Assigning Values to BOOLEAN Variables2-27. Expressions2-28 PL/SQL Enhancements in Oracle Database 11g page 4 12-November-2007 oracle.com/technology/tech/pl_sql/pdf/plsql_new_in_11gr1.pdf developers at Oracle Corporation were fluent and for which a compiler was readily available on all platforms of interest. This scheme worked perfectly well from a technical viewpoint but suffered from PL/SQL language is rich in built-in operators and provides following type of operators: Arithmetic operators Relational operators Comparison operators Logical operators String operators This tutorial will explain the arithmetic, relational, comparison and logical operators one by one. For more information, see these Oracle resources: Oracle Database PL/SQL Language Reference for information on PL/SQL, the procedural language extension to Oracle SQL Pro*C/C++ Programmer's Guide, Oracle SQL*Module for Ada Programmer's Guide, and the Pro*COBOL Programmer's Guide for detailed descriptions of Oracle embedded SQL v Contents Preface..xix Audience.. xix