PL/SQL Programming  «Prev 

OraclePL/SQL

Programming in PL/SQL is the second course in a three-part series.
  1. Extensions for SQL and
  2. PL/SQL Stored Objects
will complete your preparation for the first test in the Oracle Certified Database Administrator and Certified Application Developer track, Introduction to Oracle: SQL and PL/SQL.

DBA Certification Advice

Introduction to Oracle SQL
Exam Number: 1Z0-007
  1. Associated Certifications: Oracle DBA OCA
  2. Oracle 10g DBA OCA
  3. Oracle 11g DBA OCA
  4. PL/SQL Developer OCA
The 1Z0-007 exam will continue to fulfill the SQL requirement for 9i, 10g, 11g and 12c Database Administrator OCA paths as well as the PL/SQL Developer OCA path. However, no new 007 exams will be delivered after July 31, 2013.

SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE Data Types

The SIMPLE_INTEGER, SIMPLE_FLOAT, and SIMPLE_DOUBLE data types are predefined subtypes of PLS_INTEGER, BINARY_FLOAT, and BINARY_DOUBLE, respectively. Each subtype has the same range as its base type and has a NOT NULL constraint. SIMPLE_INTEGER differs significantly from PLS_INTEGER in its overflow semantics, but SIMPLE_FLOAT and SIMPLE_DOUBLE are identical to their base types, except for their NOT NULL constraint.
You can use SIMPLE_INTEGER when the value will never be NULL and overflow checking is unnecessary. You can use SIMPLE_FLOAT and SIMPLE_DOUBLE when the value will never be NULL. Without the overhead of checking for nullness and overflow, these subtypes provide significantly better performance than their base types when PLSQL_CODE_TYPE='NATIVE', because arithmetic operations on SIMPLE_INTEGER values are done directly in the hardware.
When
PLSQL_CODE_TYPE='INTERPRETED', 
the performance improvement is smaller.