Select All Columns From Table
949229Jul 16 2012 — edited Jul 16 2012I'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;