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
Example of Tables within a Table - SQL Example: Obtaining C_ER from COURSE and EXAM_MARK SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM_MARK AS EM

How Transactions Guard Your Database The transaction is a sequence of SQL data manipulation statements which does a logical unit of work. The Oracle treats the sequence of SQL

Character Types The Character types allow you to store alphanumeric data, represent words and text, and manipulate the character strings. CHAR You use the CHAR dataty

Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

BEGIN Parameter Description in pl sql: BEGIN: This keyword signals the beginning of the executable section of a PL/SQL block, that contains executable statements. The execut

The accuracy of product table data is critical and the Brwebean's. owner wants to have an audit file that contains information regarding all DML activity on the BB_PRODUCT table. T

Rollback Behavior When a FORALL statement fails, the database changes are rolled back to an implicit savepoint marked before each of the SQL statement execution. The Changes t

Initializing Records The illustration below shows that you can initialize a record in its type definition. Whenever you declare a record of the type TimeRec, its 3 fields supp

Autonomous versus Nested Transactions Though an autonomous transaction is started by the other transaction, it is not a nested transaction for the reasons shown below: (i)