Re: Stored Procedure Question

From: Tilen Skraba <tilen.skraba_at_igea.si>
Date: Fri, 25 Sep 1998 13:24:16 GMT
Message-ID: <4QMO1.668$4b5.14634427_at_news.siol.net>


Stored procedure?

Well, it looks more like a view.

create view bla_vw as
select city, state, zip from info_table;

So, you get the same result.

Tilen

S Metro wrote in message ...
>Actually, what I want to do is write a stored procedure like this:
>
>create procedure sp_myproc as
>select city, state, zip from info_table;
>
>Can that be done in Oracle, because it can in MS SQL Server?
>
Received on Fri Sep 25 1998 - 15:24:16 CEST

Original text of this message