Programming in PL/SQL is the second course in a three-part series.
- Extensions for SQL and
- 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.
Introduction to Oracle SQL
Exam Number: 1Z0-007
- Associated Certifications: Oracle DBA OCA
- Oracle 10g DBA OCA
- Oracle 11g DBA OCA
- 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.
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.