Blog Archives

Sequences in PL/SQL Expressions

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

This entry is part 3 of 8 in the series New Pl/Sql features 11gWith oracle 11g you can finally use sequences directly in any pl/sql expression wherever a number expression can be used. You no longer need to select from

Posted in Oracle, SQL Developer Tagged with: , ,

SQL Developer does not remember location of Java executable

A few week ago I got myself new pc. After re-intalling al my needed apps I got stuck with SQL developer asking me to point the location of the Java executable each time I started SQL developer. I was quite

Posted in Oracle, SQL Developer Tagged with:

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

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