Oracle help

[Phill Pafford]

Hello All,

I am looking for a good site that goes into details on the SQL structure for Oracle, something like MySQL site? is there one?

Also I have installed the Navicat GUI tool for Oracle but wanted to know if there might be something a little better. (Must be free ;-) )

ok my first error:


[SQL] SELECT * FROM table
WHERE field_data > 42
LIMIT 100
[Err] ORA-00933: SQL command not properly ended


This would work in MySQL, but is Oracle more like MSSQL?

if I run the query this way I get another error


[SQL] SELECT TOP 5 * FROM table
WHERE field_data > 42
[Err] ORA-00923: FROM keyword not found where expected


This is why I wanted to know if there is a good help site for Oracle.

[chazzy]

neither top n nor limit are oracle.

you need to use rownum. did you look at oracle.com?