Re: Can a procedure contain only a SELECT statement?
From: Thomas Gagne <tggagne_at_gmail.com>
Date: Fri, 19 Mar 2010 13:56:20 -0700 (PDT)
Message-ID: <d3d70ddd-3cef-4990-b188-32920d065a38_at_g4g2000yqa.googlegroups.com>
Sybrand, no need to be insecure. I'm just trying to figure out how Oracle programmers do things I've been doing since the early 90s. At present my task is to figure out how to do write procedures for Oracle and am trying to discover what it's capabilities are. Packages and cursors add complexity that doesn't exist in other products. Don't feel threatened, I'm sure there are features Oracle provides that are difficult to simulate without complexity in other DBs, like recursive SELECTs.
Date: Fri, 19 Mar 2010 13:56:20 -0700 (PDT)
Message-ID: <d3d70ddd-3cef-4990-b188-32920d065a38_at_g4g2000yqa.googlegroups.com>
Sybrand, no need to be insecure. I'm just trying to figure out how Oracle programmers do things I've been doing since the early 90s. At present my task is to figure out how to do write procedures for Oracle and am trying to discover what it's capabilities are. Packages and cursors add complexity that doesn't exist in other products. Don't feel threatened, I'm sure there are features Oracle provides that are difficult to simulate without complexity in other DBs, like recursive SELECTs.
But for the purposes of this thread, the topic is stored procedures and returns data sets either to an interactive user using SQLDeveloper or an application. Received on Fri Mar 19 2010 - 15:56:20 CDT