Re: new oracle user

tonz wrote:
> i want to run a pl/sql program from sql plus
> how is it possible?

It depends what you mean by "PL/SQL program"?

If it is a procedure (or procedure in package), use

exec procedure

If you are writing the program, use

begin

   the program code
end
/

But on that case, I recommend you type the program on a file and call it with @, like

@file.sql

So if something went wrong, you could edit the file

--
Arto Viitanen CSC
Espoo, Finland