Blog Archives

CONTINUE Statement

This entry is part 2 of 8 in the series New Pl/Sql features 11g

This entry is part 2 of 8 in the series New Pl/Sql features 11gThe CONTINUE statement exits the current iteration of a loop and transfers control to the next iteration (in contrast with the EXIT statement, which exits a loop

Posted in Oracle, Pl/Sql Tagged with: , ,

SIMPLE Data Types

This entry is part 1 of 8 in the series New Pl/Sql features 11g

This entry is part 1 of 8 in the series New Pl/Sql features 11gOracle introduced new datatype in release 1 of 11g. The simple stuf! SIMPLE_INTEGER; subtype of PLS_INTEGER SIMPLE_FLOAT; subtype of BINARY_FLOAT SIMPLE_DOUBLE; subtype of BINARY_DOUBLE These simple datatypes

Posted in Pl/Sql Tagged with: , ,

Dynamic Wrap

This entry is part 8 of 13 in the series New Pl/Sql features 10g

This entry is part 8 of 13 in the series New Pl/Sql features 10gThe 2nd release of Oracle 10g added 2 new modules to the DMBS_DLL package. WRAP; function returning an obfuscated version of your code CREATE_WRAPPED; procedure compiling an

Posted in Pl/Sql Tagged with: , ,

Automatic PL/SQL optimization

This entry is part 7 of 13 in the series New Pl/Sql features 10g

This entry is part 7 of 13 in the series New Pl/Sql features 10gAs of 10g Oracle introduced automatic PL/SQL optimization. Which has 3 settings: PLSQL_OPTIMIZE_LEVEL=0 Optimization is disabled which might be in order if you find the optimization alters

Posted in Pl/Sql Tagged with: , ,

Enhancements to PL/SQL Native Compilation

This entry is part 6 of 13 in the series New Pl/Sql features 10g

This entry is part 6 of 13 in the series New Pl/Sql features 10gThis topic is rather scarcely explained. Simply because it’s part of a much larger topic of native compilation. So the only information here is what has been

Posted in Pl/Sql Tagged with: , ,

FORALL Support for Non-Consecutive Indexes

This entry is part 5 of 13 in the series New Pl/Sql features 10g

This entry is part 5 of 13 in the series New Pl/Sql features 10gPrior to 10g any collection used inĀ  a FORALL needed to be dense. Which forced you to write extra code to compress a sparse collection or worse

Posted in Pl/Sql Tagged with: , ,

New IEEE Floating-Point Types

This entry is part 4 of 13 in the series New Pl/Sql features 10g

This entry is part 4 of 13 in the series New Pl/Sql features 10gWith release 10 oracle introduced 2 new BINARY datatypes based on the IEEE-754 floating point standard: BINARY_FLOAT and BINARY_DOUBLE. They are available in both PL/SQL as well

Posted in Pl/Sql Tagged with: , ,

PLS_INTEGER Datatype Update

This entry is part 1 of 13 in the series New Pl/Sql features 10g

This entry is part 1 of 13 in the series New Pl/Sql features 10gThe range of the PLS_INTEGER datatype is -2147483648 to 2147483647, represented in 32 bits PLS_INTEGER uses hardware arithmetic making it faster than the same operations performed with

Posted in Pl/Sql Tagged with: , ,

Change to the BINARY_INTEGER Datatype

This entry is part 10 of 13 in the series New Pl/Sql features 10g

This entry is part 10 of 13 in the series New Pl/Sql features 10gWith Oracle 10.1 the datatype BINARY_INTEGER has been changed to be the equivalent of PLS_INTEGER. Effectively BINARY_INTEGER is now only for legacy code. PLS_INTEGER should be used

Posted in Pl/Sql Tagged with: , ,

Improved Overloading on 10g

This entry is part 13 of 13 in the series New Pl/Sql features 10g

This entry is part 13 of 13 in the series New Pl/Sql features 10gOriginally overloading wasn’t possible for formal parameters that only differed in subtype. (for instance INTEGER is a subtype of NUMBER defined in DBMS_STANDARD) Starting 10.1 Oracle introduced

Posted in Pl/Sql Tagged with: , ,