pl/sql table or multiple cursors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: pl/sql table or multiple cursors

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    12

    Red face

    Hey, my question is,
    if you have a choice between declaring a cursor multiple times to return records within a nested table or make one procedure that will return a pl/sql table with the results, which would be more efficient. Obviously it would be less code writing to build a procedure to return the results, but is there anything that would make either one of these options more or less efficient.??

    Any comments would be greatly appreciated..

    Thanks

    Billy

  2. #2
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97

    Lightbulb

    The procedure is very speed.
    But you can use VIEW.
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

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