Thread: Oracle SQL

    #1
  1. The Basketball Star
    Devshed Novice (500 - 999 posts)

    Join Date
    Aug 2001
    Location
    H-Town
    Posts
    550
    Rep Power
    14

    Oracle SQL


    The Oracle website is super confusing. I don't know where to find stuff. It's nothing like the MySQL website. Anyway, our site is migrating from a PC running Windows 2000 Server and MySQL to a Linux cluster running Oracle. Anyway, hopefully you are familiar with the MySQL Manual, which is basically how to do anything in SQL on MySQL. It shows all of the ANSI standard and MySQL specific stuff. Anyway, could anybody direct me to a site similar for Oracle. I just wanna know what type of column types the accept and how to do some things in specific. I'm really not worrying about my code transfering from MySQL to Oracle because I normally go just by standard, but I want some place where I can at least learn how to create a table in Oracle and set up everything.

    Thanks.
  2. #2
  3. Wiking
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Sep 2000
    Location
    Sweden
    Posts
    3,608
    Rep Power
    26
    I don't know about the quality of the links, but there are a few -> http://www.toadsoft.com/pages.html
    And TOAD is considered as a great tool for Oracle...

    //NoXcuz
    UN*X is sexy!
    who | grep -i blonde | date; cd ~; unzip; touch; strip; finger; mount; gasp; yes; uptime; umount; sleep
  4. #3
  5. SwollenMember
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    the master control
    Posts
    264
    Rep Power
    15
    I just wanna know what type of column types the accept and how to do some things in specific
    To get the column types for a table in oracle log into sqlplus and type:

    SQL>desc <tablename>;

    this will show you the attributes.

    For creating tables and such in oracle, just do a search on google for Oracle Data Definition and you should be able to find enough information.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Australia
    Posts
    111
    Rep Power
    15
    I found a good explanation of Oracle SQL

    http://info-it.umsystem.edu/oracle/s...slr.1.toc.html

    wabirdman
    Real programmers code in binary
  8. #5
  9. The Basketball Star
    Devshed Novice (500 - 999 posts)

    Join Date
    Aug 2001
    Location
    H-Town
    Posts
    550
    Rep Power
    14
    Thanks for the suggestions. wabirdman, this is a pretty good resource although it's a bit outdatted. I'm using Oracle9i and the website is for Oracle 7. I still should be able to use it though. What keywords did you use to find the website?
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Australia
    Posts
    111
    Rep Power
    15
    Yes I realise that it is for oracle 7 but the sql syntax has not changed in versions so it will still be good to use.

    I used google and the keywords sql manual - it was the 6 item down

    wabirdman
    Real programmers code in binary
  12. #7
  13. The Basketball Star
    Devshed Novice (500 - 999 posts)

    Join Date
    Aug 2001
    Location
    H-Town
    Posts
    550
    Rep Power
    14
    I think the data types might've changed because it says that varchar2 for example can contain as many as 2,000, when I have read that it can contain 4,000 and char contains 2,000. Plus it says the default date is "12-Jan-02" when you just told me that it was "12-JAN-2002". But I'm pretty sure the SQL syntax hasn't changed.
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Australia
    Posts
    111
    Rep Power
    15
    The sql syntax should be good to use - you are right with the datatype

    wabirdman
    Real programmers code in binary

IMN logo majestic logo threadwatch logo seochat tools logo