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.

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

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.

I found a good explanation of Oracle SQL

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

wabirdman

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?

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

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.

The sql syntax should be good to use - you are right with the datatype

wabirdman