thanks everyone
can we use an alter table command in a procedure
DA Morgan wrote:
> 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)
Received on Mon Jan 09 2006 - 23:52:03 CST
