How can we see the script code of any oracle object on sql prompt using
sql command.



e.g.

If we have created a table EMPLOYEE using following command on sql
prompt.

create table EMPLOYEE (emp_no number(5)primary key, emp_name
varchar2(40))



Then after creating EMPLOYEE table how can we see the script code of
EMPLOYEE table using sql command.



Similarly if I have written a procedure, then after successful creation
of procedure how can we can we see the code of procedure using sql
command.

With regards,

Sushil Kumar





Oracle LazyDBA home page