...

View Full Version : Oracle Equivilant To A MySQL Command?



oooyeaherz
06-27-2006, 05:48 PM
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
06-29-2006, 04:33 PM
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. :)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum