Sequences in PL/SQL Expressions

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

With 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 dual

Much cleaner than the pre 11g synax:

 

 

Series Navigation<< CONTINUE StatementDynamic SQL Enhancements >>

Posted in Oracle, SQL Developer Tagged with: , ,

Leave a Reply