Home » SQL & PL/SQL » SQL & PL/SQL » Table Code
icon2.gif  Table Code [message #229867] Tue, 10 April 2007 03:40 Go to next message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
Dear All

I have created a table. and now i want to see the code/command of table creation. e.g. create table abc (a number, b varchar2(10));
once the table is created i want to see again create table command. how to do it. as we can see the views.... from user_views......

plz reply with contaxt of oracle...... i dont want to use any other tool e.g. plsql developer.... er studion or any other helping tool.

[Updated on: Tue, 10 April 2007 03:44]

Report message to a moderator

Re: Table Code [message #229871 is a reply to message #229867] Tue, 10 April 2007 03:46 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Table Structure.
desc table_name


Command Structure
set long 100000
select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual; 

Note : replace your table_name or owner in above statement.

we can see the views.... from user_views......

Yes.

Regards
Taj
Re: Table Code [message #229882 is a reply to message #229871] Tue, 10 April 2007 04:08 Go to previous message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
Thanks Dear......

It is really working and fulfilling my needs... take care

warm regards.
Previous Topic: DBMS_metata export all database with roles and grants
Next Topic: help with analitycal functiol
Goto Forum:
  


Current Time: Fri Dec 09 03:45:38 CST 2016

Total time taken to generate the page: 0.13990 seconds