SERPland Oracle, PL/SQL, PHP, Autos, Bungalow-Hotels and more …

4Jun/070

pl/sql integer stack with object types

In the object oriented word, an "intStack" is pretty well known. But how can I do this with Oracles pl/sql?
Just use an object type:


CREATE or replace TYPE IntArray AS VARRAY(50) OF INTEGER;
/
CREATE or replace TYPE IntStack_O AS OBJECT (
maximalSize INTEGER

Tagged as: , , , , , , , , , , , , , , , Continue reading
4Jun/070

pl/sql: exit an enclosing loop (leaving a labeled loop)


You can leave a loop in pl/sql by specifying a nice litte label to the loop section.
For example: <<firstloop>>

When labeling, you can exit the loop at any time. In following example, lets give the first loop the label <<firstloop>> and so on...
The third loop contains an exit statement when reaching the value of 2. With this exit the control goes back to the end of the first loop!

Tagged as: , , , , , , , Continue reading
   
Custom Search

Recent Posts

Tags

Abstract Als Amp Carpal Tunnel Syndrome Cast Application Chf Compendium Computer Mouse Der Schweiz Ein Fiat Fiat Ulysse Google Google Maps Hotels Ins Kriterien legoland Legoland Park Lt Mail Medical History Mit Nun oracle Oracle 7 Oracle Database Oracle Forms Oracle Sql Oracle Toad Peugeot Php Pl Sql Repetitive Strain Injury RSI Schweiz Solution Number Sql Code Sql Oracle Sql Statement Switzerland Toad Toad Oracle Wikipedia Wrist Pain

Recent Comments

Categories

Blogroll