I am new in Oracle development,thank u for helping me on this question.
Please don't tell me just use "desc" to get infromation of tables, it's not a good practice.
Please don't tell me just use "desc" to get infromation of tables, it's not a good practice.
http://community.csdn.net/Expert/topic/5023/5023892.xml?temp=.7249262
If you want to get the ddl of a table "dept", use this clause:
select dbms_metadata.get_ddl('TABLE', 'DEPT') from dual;
Relly appreciated your quick answers!but, what kind of tools are you talking about?I don't have Oracle developer IDE here... so, could you please tell me more about the tools you used here?
to majy,
the last command does work in SQL*Plus, but very stange, the result is not complete! the last piece of the result is missing..