Using limit - collection method, PL-SQL Programming

Using LIMIT

For nested tables, that have no maximum size, the LIMIT returns NULL. For varrays, the LIMIT returns the maximum number of elements that a varray can have (that you must specify in its type definition). For illustration, when the maximum size of varray projects is 25 elements, then the IF condition below is true:

IF projects.LIMIT = 25 THEN...

You can use LIMIT where an integer expression is allowed. In the illustration below, you use LIMIT to determine if you can add 20 more elements to the varray projects:

IF (projects.COUNT + 20) < projects.LIMIT THEN...

Posted Date: 10/4/2012 3:14:47 AM | Location : United States







Related Discussions:- Using limit - collection method, Assignment Help, Ask Question on Using limit - collection method, Get Answer, Expert's Help, Using limit - collection method Discussions

Write discussion on Using limit - collection method
Your posts are moderated
Related Questions
This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so

Package STANDARD package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available a

Built-In Functions The PL/SQL provides a lot of powerful functions to help you to manipulate the data. These built-in functions fall into the categories as shown below: error r


Fetching from a Cursor Variable The FETCH statement retrieve rows one at a time from the product set of a multi-row query. The syntax for the same is as shown: FETCH {curso

Synonyms You can create the synonyms to provide location transparency for the remote schema objects like tables, views, sequences, stand-alone subprograms, and packages. Though,

Delimiters A delimiter is a simple or compound symbol which has a special meaning to PL/SQL. For example, you use delimiters to symbolize an arithmetic operation like additio

At times, Brewbean's has changed the id number for existing products. In the past, they have had to add a new product row with the new id to the BB_PRODUCT table, modify all the co

#quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..

In Packages The Forward declarations also group logically related subprograms in the package. The subprogram specifications go in the package specification, & the subprogram b