pl/sql table or multiple cursors 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

    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..



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


    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

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