I am not new to JSL but new to Oracle SQL. I am using Mac version JMP13. I obtained database login info my company's MES.
Even if you know SQL already, and especially because you don't know JSL, it's probably best to let JMP generate all the code you need by using Query Builder. You can inspect the resulting code if you are curious. You will need an ODBC driver for OS/X.
How to tell if my JMP13 on my macbook pro is 64 bit or 32 bit? Also I have Oracle SQL developer 4.2 installed on my mac. How to check if the developer 4.2 for mac is 64 bit or not? Where can I download the ODBC driver? Thanks.
On the Mac 'JMP > About JMP Pro . . . ' will tell you if you are using the 32 or 64 bit version. For ODBC drivers I use Actual Technologies for open source databases (but not Oracle). I'm sure there are alternatives.
My answer above may have been ambiguous - If you click on the Actual Technologies link you will see that they do have an Oracle driver (but I haven't used that one). As I said already there may be alternatives, so this should not be taken as a recommendation.