Results 1 to 2 of 2

Thread: array in pl/sql

  1. #1
    Join Date
    Oct 2003
    Location
    Mumbai,India.
    Posts
    36

    Unanswered: array in pl/sql

    Hi,
    How can i use array type inside pl/sql block??

    Actually,i want to fetch values of a column first.then,i've to store the values into an array.
    how can i do this?
    thanks in advance.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Declare the array as

    type c_database is varray(5) of varchar2(12);

    then you can reference it as c_database(1), c_database(2) etc ...


    HTH
    Gregg

Posting Permissions

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