Blog Archives

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

Nested Table Enhancements

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

This entry is part 3 of 13 in the series New Pl/Sql features 10gPrior to Oracle 10g tasks like comparing 2 nested tables for equality were code intensive and had to be performed at element level. With 10g new functionality

Posted in Pl/Sql

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

Implicit CLOB/NCLOB Conversion

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

This entry is part 2 of 13 in the series New Pl/Sql features 10gIt’s now possible to implicitly convert CLOB’s to NCLOB’s and vise versa by simply assigning them to each other. However it still is recommended to either use

Posted in Pl/Sql Tagged with: , ,

Flashback Query Functions

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

This entry is part 9 of 13 in the series New Pl/Sql features 10gWith 10g Oracle introduced 2 new functions to let you translate between a TIMESTAMP and the System Change Number(SCN). A SCN represents the database state at a

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