Select In Procedure at Oracle!!(I'm beginner)

[MAHYAR E_MAIL]

Dear Friends
I want write a simple procedure that I have
One select on it like :

Select * from TableName

Then i got rows in client (Like SQL SERVER)
But i have errors on procedure
PLS-00428 : an INTO clause is expected in this SELECT Satament
PL/SQL : SQL statment ignored

Please HELP ME !!!

[Ken]

You should define a var to save the result,
eg.

select field1 into var1 from TableName

then you will find the value of var1 is the result,and you also can save
the result in a temp table.

create table(col1,col2,...,coln) select field1,field2,...,fieldn from sourcetalbe
where....










"MAHYAR" E_MAIL wrote:
>
>Dear Friends
>I want write a simple procedure that I have
>One select on it like :
>
> Select * from TableName
>
>Then i got rows in client (Like SQL SERVER)
> But i have errors on procedure
> PLS-00428 : an INTO clause is expected in this SELECT Satament
> PL/SQL : SQL statment ignored
>
>Please HELP ME !!!
>
>
>