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

Thread: Oracle stored procedure to return all records

  1. #1
    Join Date
    May 2004
    Location
    Singapore
    Posts
    1

    Oracle stored procedure to return all records

    Hi.

    Just wondering if anybody have any ideas on how to create just an Oracle stored procedure that, upon calling, could returns all records of any tables in the database?

    Thank you very much.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    ref cursor.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Sep 2003
    Location
    Washington DC area
    Posts
    12

    Angry SP it's not a stupid question

    I'm working on the samething and I've been at this for 10+ years. it's all a matter of structure. If you structure it right you dont need to code around it. This is what I've come up with. Use a basic sql statement to get what your want. "select * from table1;. Plug it into the sp and go from there.

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