Go Back   CodingForums.com > :: Server side development > MySQL > Other Databases

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 06-27-2006, 04:48 PM   PM User | #1
oooyeaherz
New Coder

 
Join Date: Aug 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
oooyeaherz is an unknown quantity at this point
Oracle Equivilant To A MySQL Command?

Hey everyone, need to figure out how to generate a CREATE TABLE statement from preexisting tables within a Oracle database. I see that SHOW CREATE TABLE in MySQL would get it done and was wondering if there's is anyway to just as easily do so in Oracle (well... even if it isn't as easy I'll try it).
oooyeaherz is offline   Reply With Quote
Old 06-29-2006, 03:33 PM   PM User | #2
oooyeaherz
New Coder

 
Join Date: Aug 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
oooyeaherz is an unknown quantity at this point
Heh, well I figured it out and since others may have the same issue then here's a link to explain it

http://www.dba-oracle.com/oracle_tips_dbms_metadata.htm

Except I would get a repeated non stop display for each time I prompt for the output... but the generated .sql script file that's located within my user account folder on xp (or do a search on your drive to see where it's at) and copying & pasting that info does the trick.
oooyeaherz is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 05:56 AM.


Advertisement
Log in to turn off these ads.