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

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

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

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

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

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

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

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

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

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