Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select All Columns From Table

949229Jul 16 2012 — edited Jul 16 2012
I'm trying to do a simple "SELECT * FROM TABLE". in a stored procedure that is obviously proving to be more challenging that I ever thought possible. I come from a MS SQL server background which I'm comfortable with. But this PL/SQL...geez.

I've done some research on this, and from what I gather, I have to use a CURSOR for the results???? Are you fricken kidding me!? Some examples suggest putting the results "INTO" a variable. But that's for one row which I don't want.

Example: i my stored procedure... vcustomers is a View....

CREATE OR REPLACE
PROCEDURE USPGET_CUSTOMERS
AS
BEGIN

SELECT * from vcustomers;


END
USPGET_CUSTOMERS;
This post has been answered by CoolBuddy on Jul 16 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2012
Added on Jul 16 2012
15 comments
6,541 views