Re: Newbie SELECT question

A view will do it

create or replace view usp_get_state as
select state_cd from state code;

The you can issue in sql*plus

select * from usp_get_state;

Mark

Programmer wrote in message <37572dc6_at_exchange.surfree.com>...
>I am new to Oracle and am used to being able to create stored procedures in
>SQL Server that return multiple rows. It was pretty simple; you could just
>create a procedure as follows:
>
>create procedure USP_GET_STATE as
>select state_cd from state_code
>
>Then, from any application, I would call the stored procedure using execute
>USP_GET_STATE.
>
>How do I do this with Oracle, since it doesn't seem that multiple rows can
>be returned in a stored proc.
>
>Thanks
>Scott
>(scott_at_metros.org)
>
>
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
>------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers
==----- Received on Fri Jun 04 1999 - 09:53:25 CEST