I love PL/SQL

Writing business logic by using PL/SQL is a good opinion to keep in database all things and in terms of security.

On the other hand, do you think that things you can do with PL/SQL is limited with this.

The following web site you maybe give hints about what sort to do much more.

www.plpdf.com

I love PL/SQL…

 

Collections in PL/SQL – Part Two

2. Nested Table

Nested Table is an another collection type. The difference from associative array I mentioned earlier is that need to initialize before using it. Besides nested tables can use as table columns.

CREATE [ OR REPLACE ] TYPE type_name AS | IS TABLE OF element_datatype [ NOT NULL ];

Example;

 

Collections in PL/SQL – Part One

How do you use arrays in PL/SQL?

In other programming language like Java and C# you simply define as following line:
int[] iArray = new int[5];

But in PL/SQL it’s not as easy as that. Why? Because there are three types of collections and we ought to know which collection type must use. Collections are expecially very useful for caching data of lookup tables. If data is cached then amount of context-switching will be less.