DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: count the size of array variable

  1. #1
    Join Date
    Feb 2006
    Posts
    86

    count the size of array variable

    i hv created an array to store multiple data and passing it to sub program thru function.

    in that sub program after some validation i hv to insert data from array to a table.now i need to find how many iteration do i need for that array.

    Is there any function in oracle which can tell the total number of elements of an Array variable ?

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    yes
    [ name of adt ].count

  3. #3
    Join Date
    Mar 2010
    Location
    Craiova, Romania
    Posts
    22
    length

    it returns the array size

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    Quote Originally Posted by crysu View Post
    length

    it returns the array size
    This is Oracle we're talking about?

    Code:
    Table 5-2 Collection Methods
    Method 	Type 
    Description
    
    DELETE Procedure Deletes elements from collection.
    
    TRIM Procedure Deletes elements from end of varray or nested table.
    
    EXTEND Procedure Adds elements to end of varray or nested table.
    
    EXISTS Function Returns TRUE if and only if specified element of varray or nested table exists.
    
    FIRST Function 
    Returns first subscript in collection.
    
    LAST Function 
    Returns last subscript in collection.
    
    COUNT Function 
    Returns number of elements in collection.
    
    LIMIT Function 
    Returns maximum number of elements that collection can have.
    
    PRIOR Function 
    Returns subscript that precedes specified subscript.
    
    NEXT Function 
    Returns subscript that succeeds specified subscript.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width