Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Aug 2005
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

  • #2
    New Coder
    Join Date
    Aug 2005
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •