SELECT DBMS_METADATA.get_ddl ('TABLE', '<YOURTABLENAME>') FROM DUAL;


Cheers!
-Kris

-----Original Message-----
From: sushil
[mailto:oracledba-ezmlmshield-x57286657.[Email address protected]
Sent: Tuesday, July 31, 2007 03:15 PM
To: LazyDBA Discussion
Subject: Procedure script code using SQL prompt in Oracle: Which command?

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






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page