What does the COUNT method do?

August 13th, 2009 by uCertify Leave a reply »

The COUNT method returns the number of elements currently held by a collection.

Syntax:

collectionname.COUNT

Example:

DECLARE
   TYPE NbrLst IS TABLE OF INTEGER;
   n NbrLst := NbrLst (1,2,3,4,5);
BEGIN
   DBMS_OUTPUT.PUT_LINE(’There are ‘ || n.COUNT || ‘ elements.’);
   n.DELETE(4); — fourth element is deleted
   DBMS_OUTPUT.PUT_LINE(’Now, there are ‘ || n.COUNT || ‘ elements.’);
END;
/

Note:

  • COUNT always equals LAST for varrays.
  • COUNT ignores the elements that are deleted.
  • When DELETE is used with no parameter, COUNT is set to 0.
  • Become Oracle OCP PL/SQL Developer certified. Get certified in first attempt download 1Z0-146 - Oracle Database 11g: Advanced PL/SQL simulation.
    Like this article? Share it with others
    If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
    • Share/Bookmark
    Advertisement

    Leave a Reply

    uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
    MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
    Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
    © 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.