How to view a created table query in oracle 10g

[Rohullah]

Hello sir

I want to view the query of a created table.
for example i create a table like this
-------------------------
create table emp
(empno number primary key,
Ename varchar2(50),
Address varchar2(250),
Phone varchar2(8),
Mobile varchar2(11));
-------------------------
For example the table created Successfully
Now after 2 or 3 day i want to view the above table query.
How to do it, I really really Need Help
Please Help me.

[amitpatel66]

You can get the DDL command using DBMS_METADATA.GET_DDL.

If you are using any tool like Toad or SQL Developer, then select the table and press F4 to have a look at the DDL.

Or

Press F8 to view the history of statements executed in the database for past few days.