dbTalk Databases Forums  

how to get table script...

Go Back dbTalk Databases Forums Databases comp.database.oracle how to get table script...

comp.database.oracle comp.database.oracle


Discuss how to get table script... in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
cy1610
 
Posts: n/a

Default how to get table script... - 07-17-2004 , 10:56 AM





Hi,

Can someone tell me how i can get table/view script by using SQL*Plus?
as i know we can get procedure and function through USER_SOURCE.

Thanks.



Reply With Quote
  #2  
Old   
Philippe Valentin
 
Posts: n/a

Default Re: how to get table script... - 07-31-2004 , 12:22 AM





Hi,

Maybe you could have a closer look to dbms_metadata.get_ddl in
"Oracle9i Supplied PL/SQL Packages and Types Reference". Bonus: there
is an example you can cut and past...
Have fun.
Ph.


"cy1610" <cylim382 (AT) yahoo (DOT) com> wrote

Quote:
Hi,

Can someone tell me how i can get table/view script by using SQL*Plus?
as i know we can get procedure and function through USER_SOURCE.

Thanks.

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top