Re: new oracle user

tonz wrote:
> thank u very much
>
> i would like to know how to edit a procedure

in SQL*Plus

set pagesize 0

SELECT dbms_metadata.get_ddl('PROCEDURE', '<procedure_name_all_upper_case>') FROM dual;

Edit with any text editor ... vi or notepad for example.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)