Blog Archives

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: , ,

Compile-time warnings

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

This entry is part 12 of 13 in the series New Pl/Sql features 10gMost programmers tend to think of a compilation as a final check. If the code compiles it’s ok. Unfortunately compilation checks syntax and dependencies and more, but

Posted in Pl/Sql Tagged with: , ,

Quoting Mechanism for String Literals

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

This entry is part 11 of 13 in the series New Pl/Sql features 10gWe’ve all come to a point where the number of apostrophes in string literal were so plentiful you couldn’t see the forest from the trees. Oracle introduces

Posted in Pl/Sql Tagged with: , ,