View Full Version : Oracle Equivilant To A MySQL Command?

06-27-2006, 04: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).

06-29-2006, 03:33 PM
Heh, well I figured it out and since others may have the same issue then here's a link to explain it


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. :)